How to removes values from dimension(Calculated Dimension)

[#1]

Hello Community,

Here I have some problem in my pivot table dimension.

I want to remove last n months  form sale month dimension in pivot table

If months are more than 12 ,so Sale Year should be remove.

please find attach image for more clarity.

thanks in advance.

Regards

R.Kumar

[sunny_talwar]

What exactly are you trying to remove? Can you elaborate what the result needs to look like?

[#3]

hi sunny ,

sorry I attached wrong attachment ,

in my pivot table I am showing sell out where I want to remove n sale months sale out details from pivot table.

ex- I have one filter MIS have values 3,6,12 and 24

If I select 3 in MIS last three sale (From Current month) months Sell out  should not come.

Regards

R.Kumar

[Anonymous · Accepted solution]

Hello Raman,

Try this:

sum({<nData={'>=$(=num(addmonths(Today(),-$(MIS))))<=$(=num(Today()))'}>}Expression1)

nData = numeric date

[#5]

thanks Fernando,

This expression really helpful to make right one.