Welcome Guest! To enable all features please Login or Register.
Go to last post Go to first unread
Shun Lu  
#1 Posted : Thursday, August 22, 2013 2:06:22 AM(UTC)
Shun Lu
Rank: Member

Groups: extranet\Forum
Joined: 5/28/2013(UTC)
Posts: 9

I want to build a bar chart between Customer's Invoice Amount and Average according to the customer's rank.

Which means I have 4 different Averages in one table. I can get average for the group but it only stays in Sub Total Column. How can I copy this number to all of the customer under that rank.

How can I create a bar chart for this problem.
Niels Thomsen  
#2 Posted : Thursday, August 22, 2013 11:14:50 AM(UTC)
Niels Thomsen
Rank: Advanced Member

Groups: extranet\Forum
Joined: 4/5/2011(UTC)
Posts: 110

Hi Shun

I hope I understand you correctly, I picture your crosstab looking something like this:

Rank 1
Customer A
Customer B

Rank 2
Customer C
Customer D

To calculate an average within a certain group I would recommend the siblings modifier (s) - perhaps a calculation looking something like this avg(d-1, all(s), m1)

This will calculate an average within Rank 1 and again within Rank 2.

Hope it makes sense.
Hope it makes sense.

Best Regards
Niels Thomsen


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.



We use cookies to improve your site experience, but they also provide us with information on your use of our website.
To find out more about the cookies we use and how to delete them, see our Privacy Policy. By continuing to browse the site, you are consenting to our use of cookies.