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:
