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\Customer
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\Customer
Joined: 4/5/2011(UTC)
Posts: 105

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.