Hey there!
I want to display percentage change in amount from previous week to current week in pivot table visualization where the data is grouped by restaurant and location. So, percentage change in amount should be displayed for a restaurant for a location in a week when compared with same metrics for previous week.
How can i achieve this?
I'm also looking for a way to calculate and show metrics on a pivot table view. e.g. grouping revenue and expenses per month, and including net profit in my pivot table. help is appreciated!
@vijaya this can be achieved using the new "OFFSET" function for calculating previous week value and then using a custom expression to calculate the variance, finally choosing pivot table visualisation