null values

[himabinduch]

HI All,

i have data from 2014Q3to 2019 Q2 and i have one pivot table.

now i want to show data only form 2014 Q3 to 2018Q1 means need to show till current quarter  reaming should be null(2018Q2 to 2019Q2)  i have attched the sample data .

Thanks in Advance.

Thanks,

hima.

[himabinduch]

Hi Rubin,

i had a try  but no luck it didn't happen for me.

is there any way to show 7 historic quarters with current quarter every time  in my case??