Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
What is the expressions for Used and subtotal here?
hi,
used:a data field from raw table,
subtatol:sum(used)
I suggest you to use field in script like subfield(used) and used expression count(total <column1> distinct used)
Now i need to get the total and distinct repeating data,not the subtotal.
Hi,
use a sheet with column1 in dimension
in expression :
concat(used,',') to have 1,2,3,4
for total :
count(distinct used)
regards
and for expression total
use option "total of the expression" and not sum of rows
hi,
Thks.
About:
for total :
count(distinct used)
is used for my subtotal ?
I'm new to qv, i have used a sheet with column1 in dimension, and have a expression by using concat(used,',') to have 1,2,3,4 , and use count expression to get avery row's subtotal number.
Now i want to get the aggergate total at the buttom. So, Where to be used this expression count(distinct used)?
add an expression, with option total and it will display total count