Calculating YTD

0

Assume i have below dataset

Brand Date Revenue Brand A 1/1/2023 30 Brand B 2/1/2023 50 Brand C 3/1/2023 60

I am trying to calculate YTD value which is Year to Date, on Jan 2023 it should be 30, Feb 2023 should be (Jan 2023 + Feb 2023 ) which should be 80, and March 2023 (Jan+Feb+Mar) should 30+50+60

Now, I need to show a matrix using Brand as rows, Month Year as columns and YTD Value as Values

To calculate YTD_revenue, I used "periodToDateSumOverTime(sum({price_times_quantity}),{receipt_date_formatted}, YEAR)" as a calculated field, but it's giving me different subtotal and total even if I chose one brand.

Yasha
gefragt vor einem Jahr350 Aufrufe
1 Antwort
0

Hi Yasha.

You can accomplish that using Period functions. Please see the following blog post (use case 2) for a sample implementation.

I hope this helps. (if so, please accept my aswer)

profile pictureAWS
EXPERTE
beantwortet vor einem Jahr

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen