Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HOW TO IGNORE FIELDS IN EXPRESSION IN BAR CHART?
=if(getcurrentfield(GeoAreaRegionTerritory) = 'GEO_DISPLAY',
Count([Quadrant_Pos]) / Count ({<[Quadrant_Pos]= p([Quadrant_Pos])>} total<[GEO_DISPLAY]> [Quadrant_Pos]),
if(getcurrentfield(GeoAreaRegionTerritory) = 'AREA_DISPLAY',
Count([Quadrant_Pos]) / Count ({<[Quadrant_Pos]= p([Quadrant_Pos])>} total<[AREA_DISPLAY]> [Quadrant_Pos]),
if(getcurrentfield(GeoAreaRegionTerritory) = 'REGION_DISPLAY',
Count([Quadrant_Pos]) / Count ({<[Quadrant_Pos]= p([Quadrant_Pos])>} total<[GEO_DISPLAY],[AREA_DISPLAY]> [Quadrant_Pos]),
Count([Quadrant_Pos]) / Count ({<[Quadrant_Pos]= p([Quadrant_Pos])>} total<[GEO_DISPLAY],[AREA_DISPLAY],[REGION_DISPLAY]> [Quadrant_Pos]),
)))
attached a sample file, similar to the requirement
Hi raghubharath
Can you attach the sample file, please. Thank you.