on 03-08-2018 9:18 AM
Hi everyone.
I want to count the number of files which have a number of customer >=2 and have the total amount.
I've tried some formula with Sum, Count, with a variable but I can't have the result as I want.
My first column is a simple dimension [A]
My second Column is a calculated column is calculated Count[B]
My third is an indicator [C].
Someone know how to get the results of number of files >=2 and the total amount associated ?
Thanks
Create Amount as dimension variable and then use like
=Sum([V Amount]) where ([No of Customers]>=2) foreach ([ID Files])
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
ID Customer is a dimension I used in the screenshot in the second column, it's Count(ID Customer) (Count[B]), each Files has 1 or more customer.
I made a variable which execute If(Count(ID Customer)>=2;"True";"False").
But each time I confirm the syntax, it converted it in Indicator (instead of Dimension) and I don't know why. And after, when i made a filter on "True", I have the line I want. But next, when I execute the code Count(ID Files), the result is the total of files, not only thus which have >=2 customers.
User | Count |
---|---|
89 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.