en
Welcome Guest! To enable all features please Login or Register.
Options
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

Hello
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.

ImageB

Thanks!

Ahmad
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: 182

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

UserPostedImage

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
Elin Petersen  
#3 Posted : Friday, July 7, 2017 10:37:39 AM(UTC)
Elin Petersen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 6/26/2012(UTC)
Posts: 12

Originally Posted by: Pá Go to Quoted Post
Also format the total/average as Column totals after members.
This way you get a new placeholder row per dimension A.


Hi.

What does that mean? How can I do it?
Thanks for your help.

Best regards
Elin

Páll Bjarkason  
#4 Posted : Thursday, July 13, 2017 9:35:03 AM(UTC)
Páll Bjarkason
Rank: Advanced Member

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

Hi Elin

Right click the crosstab and select Table -> Totals and subtotals ->
Column totals after members

NB The average (avg) part of the calculation is visible in the "Column total" row. In the screenshot the name of "Column total" row is Average and one of the average numbers is 72,744.81.
Best regards

Páll, CTS
Users browsing this topic
Anonymous
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.

Notification

Icon
Error