Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
we have 1 requirement where data in straight table is look like this
id | sales | month |
1 | 100 | Jan-13 |
2 | 200 | Feb-13 |
3 | 300 | Mar-13 |
4 | 400 | Apr-13 |
5 | 500 | May-13 |
6 | 600 | Jun-13 |
7 | 700 | Jul-13 |
8 | 800 | Aug-13 |
9 | 900 | Sep-13 |
10 | 1000 | Oct-13 |
11 | 1100 | Nov-13 |
12 | 1200 | Dec-13 |
13 | 1300 | Jan-14 |
14 | 1400 | Feb-14 |
15 | 1500 | Mar-14 |
and 1st initial requirement is to show the data like data should display in a monthly columns@ and than restrict it for rolling 24months data from available 36 months..how this scenario is possible
id | sales | Jan-13 | Feb-13 | Mar-13 | Apr-13 | May-13 | Jun-13 | Jul-13 |
1 | 100 | |||||||
2 | 200 | |||||||
3 | 300 | |||||||
4 | 400 | |||||||
5 | 500 | |||||||
6 | 600 | |||||||
7 | 700 | |||||||
8 | 800 | |||||||
9 | 900 | |||||||
10 | 1000 | |||||||
11 | 1100 | |||||||
12 | 1200 | |||||||
13 | 1300 | |||||||
14 | 1400 |
kindly suggest
Hi virendra,
Try this expression in your chart,
=sum({<MonthNameField={">=$(=AddMonths(MonthNameField,-24)"}>}sales)
Hope it work for you.
-- Regards,
Vishal Waghole
=sum({<MonthNameField={">=$(=AddMonths(Max(MonthNameField),-24)"}>}sales)
Hey extremely sorry i forget to add Max(MonthNameField)
sum({<MonthNameField={">=$(=Date(AddMonths(Max(MonthNameField),-24),'MMM-YY'"}>}sales)
sorry to say but this set analysis will help me find out the rolling sum of data .but i want individual presence of the 24 months and data should visible accordingly.
i dont want rolling some data for last 24 months.
i want to show last 24 columns without any current selections.