Hi All!
I created a small test application in which I want to calculate the percentage of the sales budget like as in the table:
| Day 1 | Day 2 |
|---|
| Actual(Day) | Budget(Month) | Actual(Day)/Budget(Month)*100 | Actual(Day) | Budget(Month) | Actual(Day)/Budget(Month)*100 |
I carefully studied https://community.qlik.com/blogs/qlikviewdesignblog/2012/10/26/mixed-granularity (thanks to author!) but I can not do it either.
The task was solved only by splitting the common calendar into two tables - months and days, and then creating a common link table.
Please help, is this the correct way?
File is attached.
Thank you in advance!
