Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a pivot table and when I select one value in my dimension, the line return 0, someone please, help me?
The expected result is, if I select or no the dimension (Period) the result to dimension is the same, not 0 when select one
sum({<period-={'$(=min(period))'}>}[value])
You can either
1) Ignore ALL Selections as below
sum({1<period-={'$(=min(period))'}>}[value])
2) Ignore Selections in specific fields by adding them to the set as below
selections in [fieldname] and [fieldname2] will be ignored
sum({<period-={'$(=min(period))'}, [fieldname],[fieldname2]>}[value])
Ignore selections on filed & filed1 as follow :
sum({<period-={'$(=min(period))'}, field=,field1=>}[value])
if you are selecting the field period, and you have period as one of the dimensions, try using the following instead:
=sum({<period=e({<period={'$(=min(period))'}>}period)>}[value])
if period is a date remember to convert min to a date using your format:
=sum({<period=e({<period={'$(=date(min(period),'MM/DD/YYYY'))'}>}period)>}[value])