Skip to Content
0

Count dimension with filter on another count

Mar 08 at 09:18 AM

27

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Mar 08 at 09:24 AM
0

Create Amount as dimension variable and then use like

=Sum([V Amount]) where ([No of Customers]>=2) foreach ([ID Files])

Show 6 Share
10 |10000 characters needed characters left characters exceeded
Former Member

I've tried, but it's doing #MULTIVALUE with this formula

0

try with adding dimension object in foreach which you have used to calculate "number of customers"

0
Former Member
AMIT KUMAR

I tried but this time I've blank cell (no result).

The formula I've made is
= Sum([V Amount]) where (Count([ID Customer])>=2) foreach ([ID Customer]) and there is no result.

0
Former Member
Former Member

Wrong formula before, but this doesn't work also
= Sum([V Amount]) where (Count([ID Customer])>=2) foreach ([ID Files]) and there is no result.

0

what is ID Customer.it's not there in the screenshot..if you can update the screenshot with all object available then i can try my side and let you know the solution.

0
Former Member
AMIT KUMAR

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.

0