Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello guys,
I discovered few days ago the option "limitation" in the pivot table.
I wanted to print only lines for which my measure is equal to 1.
This is my formula measure : wildmatch( aggr( NODISTINCT sum(AMOUNT),[com]) =0,0). It gave my 1 if the sum<>0.
The limitation option doesn't work, and I don't know why ? do you think this can du to the number format ?
Thanks a lot
Behind a screen of the limitation option I used
this option is to limit the number of rows, it does not check the values in the field
if you want to limit dimension based on a measure try below
Calculated Dimension
=if( aggr( NODISTINCT sum(AMOUNT),[com]) >0,YourDimension,null()) << Uncheck show null values on this column
Or you can just Add Dimensions
Com
Entity_cc_company
Measure = Sum(Amount)
Then Under Data Handling >> Uncheck Include 0 values
this will hide all rows where (Sum(Amount)=0)
Hello vinieme12,
Thanks a lot for your answer
Yes it works but I would like to avoid if expression.
Thanks for this second solution
Good idea, but I've got other measure in my table so it doesn't work.
then Option1
either use a calculated dimension as shown above
or Option2:
change your measure
Measure = if(Sum(Amount)>0,Sum(Amount)) and then Under Data Handling >> Uncheck Include 0 values
NOTE: you will have to check if(Sum(Amount)>0, OtherMEasure) for all other measures in that chart