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？
Solved! Go to Solution.
If I understand :
you want count for each line, and count distinct as subtotal ?
if so : in subtotal expression write :
so subtotal 6, and not 7 because of a duplicate
I suggest you to use field in script like subfield(used) and used expression count(total <column1> distinct used)
for total :
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)?