Forum Discussion

Dellis81's avatar
Dellis81
Icon for Post Prodigy rankPost Prodigy
3 years ago

Paginated report measure groups

Hello, as I continue down my trail of learning/implementing paginated reports - I would like to organize the groups by like kind measures (expressions)

 

In this example, I have Years, then 3 differing measures.    I would like to have have the same measure as a top group, and then years as second tier.   Below is a screenshot of what I have in Paginated.

This second screenshot is desired result (as formated in excel)

 

In PBI, I would use a calculation group, with each measure defined as a item..   However, I have not been successful in that attempt?    Do calculation groups work within PAginated?

 

Or other workarounds?   I appreciate any thoughts or links that might be of value.

thank you! 

 

 

1 Reply

  • Hello, to hopefully clarify my original request.    Here's an example of using calculation groups w/PBI to group measures by year.    I am hoping to have a similar report w/Paginated.  But, as in above example - I don't quite have yet.

     

    Greatly appreciate if someone has thoughts or provide a thought on how to proceed.   I am unable to make calculation groups work inside SSRS. 

    Also, please advise if there are alternative forums to post paginated questions.  I know, I am not quite in the right space. 

    thank you!