Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI i have a Pivot table in Sense with two dimension ,
Country Name and Country Name & '-' & [New PST]
now i want to exclude value from [New PST] which are ABC and CBA
the result i am getting is i can exclude those value but i am still getting county name associate with that value.
May be try this
If(Len(Trim([New PST])) > 0, [Country Name] & '-' & [New PST])
and then make sure that you uncheck 'Include Zero Values' for your dimension
How exactly are you excluding them?
I created new field in script to exclude them, Field name as [New PST].
So basically its already exclude , but i am still have Country name associate with that .
Why don't you exclude it via set analysis?
I have exclude that on measure using set analysis , i still see country name associate with those value , getting 0 on all measure.
=[Country Name] & '-' & [New PST] this is my expression for second dimension
I am not sure I follow your comment. Can you show this via sample or images?
Again first dimension [Country Name] and second dimension =[Country Name] & '-' & [New PST]
May be try this
If(Len(Trim([New PST])) > 0, [Country Name] & '-' & [New PST])
and then make sure that you uncheck 'Include Zero Values' for your dimension
Thanks Again it just worked fine