Hello, I would create a graph to compare the yearly turnover in the same period.
I mean: considering we are in July I would see the previous years turnover from January to June, next month I would seefrom January to July and son on.... Can you help?
Yes, my date is with format dd/mm/yy
I created a file with fake datas, how can I send to you once it's linked on my google drive?
You can send me the dashboard and the file by separately then.
Please share your files to this email: support@infragistics.com
With the following subject: [R+ Forum Post] Compare yearly turnover same period.
Hello!
Let me know if I can be of assistance.
Regards,
Email sent
Hi,
To conclude the case we reviewed the dashboard.
The unexpected amounts were due to the use of the new calculated fields in pivot values with the default SUM aggregation.
For this scenario, where the calculated fields are already 'aggregated values', the aggregation setting should be set to min or max to prevent the value not being aggregated again.
Best reagads,