Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI -
I am looking for a formula that will help me filter my chart by Type 1/2 dimensions.
In other words i wanted to display COUNT by location for Type 1/2.
Fields:
Dim1. Date
Dim2. Location
Dim3. Type. 1.Type 2. Type.3, Type.4,5,6........
Measure. Count
Is this possible? Please help.
Thank you,
Hi zvirina 123
Just for understand better your issue, you need that your Chart only Display count of your Measure when the Measure is on type 1 and 2??
If yes, you can try this:
Count({<Type={1,2}>}Measure)
Let me know if it works!!
Greetings.
Hi zvirina 123
Just for understand better your issue, you need that your Chart only Display count of your Measure when the Measure is on type 1 and 2??
If yes, you can try this:
Count({<Type={1,2}>}Measure)
Let me know if it works!!
Greetings.
THANK YOU
Another question. What if i need to do Sum(Distintct(.....the formula you gave does not work with sum.
Any other suggestions?
Thank you
HI
Try like this
Sum({<Type={1,2}>}Measure)
what about distinct?
Hi,
You can use it, you could try this:
Sum(Distinct {<Type={1,2}>} Measure)
Share us the results please
I did and that does not work. Any other suggestions?
Thank you
Can you attach you qvw, maybe I can help you more with an example
Greetings