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?
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
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