Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to add a table where I have 2 summary fields as expression (total value for example). In the dimension I want the top line to be Total and the second line to be the total where a certain criteria is met. What is the best way to achieve this?
For example
sum value
Total 2500
with criteria 1800
many thanks
can you attached your sample file...
i didnot get you exactly
Hi, many thanks for your help. The raw data looks like:
number criteria1 criteria2
acnumber1 1 0
acnumber2 0 0
acnumber3 0 1
acnumber4 1 1
what i would like to show is the number of accounts that meeti criteria1 and the number that meet criteria2 and the total in a straight table.
My dimensions would be the criterias and only count the account number where this is met. I have set up a flag for this criteria so it shows as 1 or 0, I would like to summarise this data as below:
number of accounts
criteria1
criteria2
please let me know if this does not make sense.
Hi, many thanks for your help. The raw data looks like:
number criteria1 criteria2
acnumber1 1 0
acnumber2 0 0
acnumber3 0 1
acnumber4 1 1
what i would like to show is the number of accounts that meeti criteria1 and the number that meet criteria2 and the total in a straight table.
My dimensions would be the criterias and only count the account number where this is met. I have set up a flag for this criteria so it shows as 1 or 0, I would like to summarise this data as below:
number of accounts
criteria1
criteria2
please let me know if this does not make sense.
Would you accept, as result, the data (criteria1, criteria2, total) in diffent columns instead of rows?
Regards,
Daniele
Hi,
I attached a solutions.
Regards!