Data for Latest Month available for selected Year

[manpri7078]

Dear All,

I am trying to build expression for displaying data for latest month for the selected year when only year is selected and month is not selected.

And also data for the previous N number of Months. All this for the dimension defined in the straight table chart.

For Example if I select 2017 and the latest data available is for the month of Jun-17 and If I define N number of months to 5, then my output be

1st Expression -  Data for Jun-17

2nd Expression -  Data for May-17

3rd Expression - Data for Apr-17

and so on till Feb-17.

Please guide me for the expressions to be built in.

Regards,

Manish Prasad

[manpri7078]

No, I want to hide the entire column as if there is only one dimension, as basically that column will not be showing anything. Only it is used for the calculations of the expressions built there in.

Regards,

Manish Prasad