Forum

This content is now out of date.

Visit Our Community

Calculated total for percentage variation in month comparison reports

Dear support,
I've built a report to compare two months data: I'm using 2 sub-queries, one for each month, and then comparing them in the main report.

I need a field to calculate the customer variation between the months:I can manage to calculate the % difference for the dimension "Segment Group", but I can't get the total eprcentage, as the "Calculated Totals" is not working.
Here the report:

Forum image


I've tried to calculate the percentage in several different ways, but I can get only the right percentage for each line, or the right total, but not both!

I have 3 calculated fields:
- % of Difference 1: calculation is right on each dimension line (4.0%, 5.4%, 5.4%), but the calculated total is wrong! Here the details: I calculate the difference, and then show the result af a Percentage of the column "active Last Year"

Forum image


Forum image


- % of Difference 2: calculation is right on each dimension line (4.0%, 5.4%, 5.4%), but the calculated total is wrong! Here the details: I calculate the difference and multiply it for 100, and then show the result af a DIvision of the column "active Last Year"

Forum image


Forum image


- % of Difference 3: calculation is right on the total, but wrong on each dimension line! Here the details: I calculate the difference and multiply it for 100, and then show the result af a DIvision of the column "active Last Year"

Forum image


Do you have any suggestion on how to build the Calculated field to get the right result for each dimension row and for the total?

Thanks,
Francesca
Sorry here the report:

Forum image


Cheers
Francesca
Hi Francesca,

sorry for the delay! If you'd like to add more than one inline image to a forum post then please don't forget to click the Add another image button after you've Browsed for your 1st image for the inline attachment:


Forum image


So, if you wouldn't mine, could you please try again to add in all of the screenshots you had prepared for this post and then we can look into the problem.

regards,
Dave
any response to this question? I am trying to build a monthly sales growth report across several departments. I can get the report to work just find as a cross tab but can not figure out how to get a percent change in sales from month to month.

Scott

Thanks for trying Yellowfin

Please complete the form below to request your copy of Yellowfin today.