Hello,
Looking for some help to correct a table. Originally I was using YTD data, and using set analysis to lock onto one month. After a change from the users, I have been given MTD data. I am no longer using Month in my set analysis, but I would like the current month if no selection to show under month. If a month is selected, I would like that to show, with the data showing YTD through that month.
Is this possible?
Here is a picture of the table:
Since I am using Dimensionality as a way to show the variance below, I need a way to create different rows. Another way to create variance below the sales of the month would be fine as well.
Here is a sample of the code:
=
if ( Dimensionality()=0,
((sum({<[NEW RENEW IND]={'COMBINED'}, YEAR={$(vBusinessYear)}>}[SALES])/1000000)-
(sum({<[NEW RENEW IND]={'COMBINED'}, YEAR={'PLAN'}>}[SALES])/1000000)),
sum({<[NEW RENEW IND]={'COMBINED'}, YEAR={'PLAN'}>}[SALES])/1000000)
Thank you for the help,
Justin