Hi All,   Is there a way to format values in a cross tab based on the combination of row and column header values? Please refer to the attachment. I need Toyota-Brisbane, Toyota-Los Angeles and Toyota-Paris values always coulored pink.   I couldn't find a way to do so using display rules.   Thanks in advance!     ... View more

I need to convert below table into crosstab. Month would be rows, range would be columns and measure has to be % of balance by row (per month).   I've tried "Percent of Total", but it calculates % of overall total but not % of row total.   Any help is greatly appreciated.   month range Count  Balance  Jan-15 <30 18  $              996,958 Jan-15 <60 83  $        324,331 Jan-15 <80 153  $        271,065 Jan-15 <90 91  $        2,761,917 Jan-15 <100 58  $        9,227,751 Jan-15 100+ 3  $              995,563 ... View more