How to write this expression

[#1]

Hi All,

I have those data:

load * Inline

[DayDate,Cohort,MemberId

2013-1-1,1,1

2013-1-1,1,1

2013-1-1,1,1

2013-1-1,1,2

2013-1-1,2,1

2013-1-1,2,2

]

;

And I am using pivot table to show the active MemberId by DayDate by Cohort

The result will be

DayDate, Cohort, ActiveMembers

2013-1-1, 1, 2

2013-1-1,2, 2

For the ActiveMembers, I use count(distinct MemberId), What I want is add one more column to show the total ActiveMembers by DayDate by Cohort. that is 4

DayDate, Cohort, ActiveMembers

2013-1-1, 1, 2

2013-1-1,2, 2

Total:         4

What Shall I do?

Thanks.

[zhadrakas]

hello,

is this what you want?

regards

[johanlindell]

Make a sub-total for the "DayDate" column and make an Aggregate expression on the dimensions you want to aggregate by.