Hello Community,
I am struggling with YTD summaries for %-values. In image 1 I have lines for Revenue and Costs and then I have added metric “Costs” for a second time and I am showing the value as % of Revenue.
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/205735ca-9af2-4a67-a94e-00477ab0936f.png)
When I add YTD calculations (Image 2), I have an issue that also the “% of Revenue (Costs)” seems to be cumulating when in fact it should be always calculated as Costs/Revenue.
This means that for February YTD (ACT) shows -2.20 % (= -1.30 % + -0.90 %) instead of the calculated values, which should be -1.11 % (= -4 664 / 419 306).
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/3f6868cb-9431-48c3-ba24-9debe99dcda7.png)
Is it possible to keep the YTD calculations for other metrics, but use a “formula”-calculation for the %-metrics?
In case it is any help, here is also a image of how I have pivoted the data.
![](https://uploads-eu-west-1.insided.com/pigment-en/attachment/9558aab3-99de-4032-9af2-4d765cc868c0.png)
Best answer by Benoit
View original