Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
Ahmad Baara  
#1 Posted : Friday, December 5, 2014 10:59:17 AM(UTC)
Ahmad Baara
Rank: Newbie

Groups: extranet\Forum
Joined: 4/1/2011(UTC)
Posts: 2

I have tried searching for this and the help documentation to no avail.

I have a cross tab that looks like this

Image A

I added the average calculation that shows in the bottom, however I want the average for each DimensionA member for each Quarter such that it will look like this.



Páll Bjarkason  
#2 Posted : Friday, December 5, 2014 1:37:58 PM(UTC)
Páll Bjarkason
Rank: Advanced Member

Groups: extranet\Forum
Joined: 1/13/2012(UTC)
Posts: 156

Try this calculation in a custom calculation "as a new measure"...


Change the dynamic caption for the default Total, which is used to hold the average: "Edit dynamic captions for this members on this level". Delete {cellvalue} and type Average.
Also format the total/average as Column totals after members.
This way you get a new placeholder row per dimension A.
Lastly you can hide the original measure.

Edited by user Saturday, December 6, 2014 9:21:45 PM(UTC)  | Reason: Not specified

Best regards

Páll, CTS
Users browsing this topic
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.