Hi,
I want to have a calculated field run the calculation after group by is done in a pivot table. For eg
Date
2022-Aug-01 , Value1 = 100, Value2 = 2 , Calculated value = 98
2022-aug-01, Value1 = 90, Value2 = 3, calculated value = 96.67
When i do a pivot table I will group by Date, but i don’t want to use Average (97.33) which I don’t want to use, instead I need to Sum(value 1) & Sum(Value2) and apply my calculated value (97.36)
Please let me know