Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
fsilva1
Contributor II
Contributor II

set analysis return 0 when select dimension

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]) 

Labels (2)
3 Replies
vinieme12
Champion III
Champion III

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]) 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
cedfoning
Creator
Creator

Ignore selections on filed & filed1 as follow : 

sum({<period-={'$(=min(period))'}, field=,field1=>}[value]) 

edwin
Master II
Master II

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])