Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to count all data by type in the table, no matter if I select month or quarter or date.
i.e. if i select month 3, the count must be 10 (Type 1). and 9 for (Type 2).
if i select quarter 2, the count must be 10 (Type 1). and 9 for (Type 2).
if i select date 01/03/2018-03/03/2018, the count must be 10 (Type 1). and 9 for (Type 2).
Thanks for your help.
count({1}Type)
or
count({<Year=,Month=,Date=.Quarter=>}Type)
Thank you Chanty 4u , and if I want to add a condition "and" something like this:
count({<Year=,Month=,Date=.Quarter=> (and valor>0)}Type)
Thanks
count({<valor={">0"}, Year=,Month=,Date=.Quarter=>}Type)
May be this
count({<Year=,Month=,Date=.Quarter=,valor={">0"}> )}Type)
Hi
I think you need something like this :
Type in dimension,
and in expression :
count( {1<Type = P({$}) >} type)
regards