How to add Aggregate data

[Anonymous]

hi，

I want to use aggregate row to distinct data in straight，just like bellow：

But i found the straight table's  aggregate  can't do this,it can't use expression to distinct repeating data。Column1 is a dimension,used and subtotal is expression.So i want to add a aggregate  row  at the bottom by using expression to distinct repeating data.

Am i right ? and Who can help me？

Thks

[ogautier62]

Hi,

did you try ?

is this what you want ?

[Anonymous]

Hi，

Sorry to bother you，i have a question.

i have some expressions,one of them is subtotal, and like below：

i have written ‘count(user)’  in subtotal expression,and this expression can enable repeating data.

If i use dimension total like below：

Where do i write script like ‘countil(distinct user)’ ?

Do you understand me ?

[ogautier62 · Accepted solution]

HI,

If I understand :

you want count for each line, and count distinct as subtotal ?

if so : in subtotal expression write :

if(dimensionality()=0,count(distinct user),count(user))

so subtotal 6, and not 7 because of a duplicate

regards

[Anonymous]

Hi,

yes，just it is what i want.

Thank you!

I will try again.