I have a calculated measure on my SA workbook. consists of both a max value and a sum value, but on the grand total it just shows the max of that field. I want that to show the summary though.
In general, the use case for this is I have forecast records that I'm wanting to access from a sales order SA pivot table and want to access then sum properly given the correct date context on the pivot table.
E.g. below
Planned Amount (Max) is a formula field that is basically finding the forecast that matches the item and customer and if that forecast has the correct month it pulls in the forecast number, else it is 0
Planned Amount Sum was meant to basically be the same as Max but I thought it would sum(it didn't). It is a calculated measure: {Planned Amount (SUM)} / ({Planned Amount (SUM)} / {Planned Amount (MAX)}
basically I was just trying to get the same data but have it be a sum in the total and not a max, but this didn't work.
Any help on this would be greatly appreciated! Or if I'm totally off base on how I'm approaching this I'm very welcome to feedback or suggestions!
Thanks!