Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
Please check my loaded data of which month/year field takes value. How calculated dimension be applied to correct this as this goes as a dimension field!. Also appreciate if steps are properly laid down to correct through number tab!
Thanks
Neville
Excel used
BRANCH | MONTH/YEAR | MOTOR | NON_MOTOR | TOT_PREMIUM |
RA | January-16 | 100,000 | 250000 | 350,000 |
RA | February-16 | 250,000 | 300000 | 550,000 |
RA | March-16 | 350,000 | 150000 | 500,000 |
RA | April-16 | 450,000 | 350000 | 800,000 |
RA | May-16 | 500,000 | 250000 | 750,000 |
RA | June-16 | 583,333 | 150000 | 733,333 |
RA | July-16 | 658,333 | 200000 | 858,333 |
NO problem. Just to correct you it is Vishwarath, so there is no N in my name.... 🙂
Sorry, I will correct it!
Neville
Oh you don't need to be sorry. That's cool just correcting. 🙂