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?
Hello Tommaso,
Thank you for your support request!
Would you mind sharing an example of your data? Depending on what you have is what we can do to visualize the monthly turnover year over year.
Looking forward to hearing from you,
Ok, I have the following datas:
I would create these calculated fields:
PrevYear: sum all the amount from 01/01/2015 to 01/07/2015 (the final date must be the current month - 1 year)
CurrYear: summ all 2016
Hope it help to understand my requirement.
Thank you.
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.
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,
I will send you an email