Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can anyone please help me on this.
In the Pivot Table
Dimensions: Row1,Row2 Fields
Column: Column field
Measure:
Pick(Match([RAG]),2,1,0,3),'R','A','G','W')
Now the requirement is I have to derive one Status Column with the below logic
Under Column Field have the records like Electronics,Fruits,Clothes,Books,Remotes,Robos,Products.
If all these records are W then the the status should be W
If any of the record contains Red then the Status should be R.
Please provide the solution to get the status column with the above condition.
Thanks in advance
Hi,
Instead of Adding Group in the Dimension Can you add an expression for each group.
Something like below.
Kindly find the attached Updated file.
Thanks,
Mukram.
Hi,
Can you share sample data file.
Hi,
Instead of Adding Group in the Dimension Can you add an expression for each group.
Something like below.
Kindly find the attached Updated file.
Thanks,
Mukram.