If you are unable to create a new account, please email support@bspsoftware.com

 

YTD Change and YTD Growth do not roll up for Subtotal(exluded) member

Started by pricter, 16 May 2014 08:46:13 AM

Previous topic - Next topic

pricter

I have create a very simple report in Analysis Studio.
I place Products as rows, and YTD Grouped as Columns and Revenue as measure
I excluded one product and then I select to display 'Subtotal (excluded)' for rows.
YTD and Priod YTD roll up correctly in  'Subtotal (excluded)'  but YTD Change and YTD Growth have -- in  'Subtotal (excluded)'
If I use the calculation %difference the roll up works.
Does anyone else has face this issue?

clayton

hi

Just follow up your steps, it works fine. I didn't face that issue. It is better to provide more information, like how do you design the YTD group in the transformer model.

Best regards,
Clayton Yan

pricter

I used for my test the sample cube Sales and Marketing and I get the same error (see attached)
In this cube I did not design the YTD it was ready