How to ignore the dimension in Chart by set analysis?

[#1]

Hi All,

I use pivot table to show the records.

There are 3 dimensions in that object and on expression in it like sum(Amount).

I understand we can use total to ignore the affect of all dimensions like sum( {1} Total Amount), but I just want to ignore one of the dimensions, how to achieve

it?

Thanks.

[jagan]

Hope this helps you!

Sum(TOTAL <Dimension Name> Amount)

Regards,

Jagan.

[#3]

Hi,

Thanks for you reply.

I have the following tables:

load * inline
[
SynKey, ClassType,BookId
1, A,1
2,A,2
];

load * Inline
[
SynKey,AgeGroup,MemebrId
1,01,1
2,01,2
3,01,3
];

That two tables are connected by SynKey. The first table show the Class book status, and the second table show the Member information.

Now I want to show the figures in the pivot table: Use ClassType and AgeGroup as dimensions. But I want to show the total Members based on Age Group, even though they do not attend relevant Class.

The correct result looks like this:

Class Type, AgeGroup, BookUsage, Members

A, 01, 2, 3

But the my doc show the different result. I have attached it, could you have a look at it?

Thanks.

[jagan]

Hi,

Use this as second expression (Members)

Sum(AGGR(Count(MemebrId), AgeGroup))

Regards,

Jagan.