Need to add a column in above pivot which shows [Dezired RAG] only on PCE Total values(for e.g. FostexxxxxxxxxxTotal) : Note: I am using Excel 2013 power pivot. No Power Query.
RAG Table: >90 days then "R",>30 days then "A"
Note: I have used: RAG Measure:=IF(MAX([Max DPD])>90,"R",IF(MAX([Max...