It would be great if you attach a sample workbook based on your worksheet layout will try to change the calculations
It is possible to combine the two operations in the following order. First create the LOD expression which will give the percent of total per location and then apply the table calculation to calculate difference in percentage points per year (as long as you have the date/year field in the view).
Let me know if you require further assistance.
Could you please provide the twbx file?
I use the superstore sample data to do a similar situation.
To show the yearly change for each segment and all segments.
I create 2 kinds of LOD expr CF, one is for exclude segment (so it will show the change of all segments in the view).
the other one for fixed year (so it will show the change of all segments in the data source)
As the attachment.
filterLOD_0824.twbx 359.1 KB
of course I can provide some data.
in this case (since the data is confidential, I used the superstore data).
What I want to do is to get the relative comparison between both worksheets created in the report. I assume there is another way in one worksheet, but i am stuck at this point...
YoY Comparison.twbx 2.4 MB