Skip to Content
0
Jun 29, 2021 at 01:45 PM

Value sort on Version differences

176 Views Last edit Jun 29, 2021 at 03:48 PM 4 rev

Hi Experts,

I have a table on a SAC planning model with (sales) values in 2 versions: "ForecastV1" and "ForecastV2".

How can I create a delta report that is sorted on the highest (difference) values?
where "Delta" = "ForecastV2" - "ForecastV1"

Because when using cross calculations in a table, it seems we cannot perform value sorting on a calculated (cross calculation) and we are forced to select a specific version.

example:

Attachments

capture.png (9.4 kB)