Variation Column that results "%" or "pts" in the same cell depending the account selected

diogocorazza

Hello Everyone

 

I'm trying to find a creative way to report the line items in rows and columns with amounts, variance $ and variance %/pts (the last in the same cell). In the screenshots below is the ideal formatting. Unfortunately Anaplan allow me to use only one Line Item, so I cannot create customized columns and be "creative" with a single column for the Variance in % or Pts depending the line item selected. If I choose to use a LIS for accounts and create this columns as line items I have another problem, because I need to use the Collect function and it return as a number unique format, but I need some accounts in amounts and others in % and still need to compare IF amounts in %, OR IF % in pts. I think I need to know if this is impossible in Anaplan and reports the way we not like or if anyone has a creative way to report in the ideal model below. (the team that helped us developing our project told me it is impossible, so he created 2 reports: one for Amounts and variance in % and other for % and variance for pts).

The final problem is that I would like to report in sequence the corresponding accounts, even if need to mix Amounts Accounts or % accounts in the the report.

Thank You

 

As is today:

REP1 

 

 

REP2

 

 

Ideal: 

 

 

diogocorazza

Thank You @ChrisAHeathcote  and @rob_marshall 

 

Yes, that's what I would like to know because I'm almost a week trying to solve this. If this is not possible I can move on and accept the way it is.

 

Thanks!