Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Duggen
Contributor
Contributor

Issue with P&L Pivot dimension

Hi all

I´ve made a P&L Pivot, with 2 dimensions, one is a lot of sales rep´s, and the other Dimension have like 100 different values, but I only want to show one specific value...is it possible to write a string /formel in "Field" or "Label" so I only get this one value ?

 

 

 

(I know can make a filter andBI Question.png choose this specific value, but in this sheet I need 2

P&L Charts having different dimensions)

rgs

Duggen

 

Labels (3)
1 Reply
brunobertels
Master
Master

Hi 

May be like this 

Aggr( if( MyDim='A' OR MyDim ='B',MyDim, Mydim)