filter or avoid values

[raadwiptec]

hi

I have a pivot table as below

Customer  Period    012016  022016 032016  042016  052016  062016  072016  082016  092016

1                               10        20         10        20           10        20         10        20

2                                10        20

3

4

10,20 are all the quantities sold..

now i would like to avoid the current month while it is getting refreshed..once in a month the data gets uploaded.. for ex.. if april is the month.. then while reloading 042016 should not be displayed..and the same report is used as a straight table for another analysis..so changes also should not impact the straight tables..

[Digvijay_Singh]

Do you mean you are using fast change icon in the caption to convert into straight table for different purpose?

Also just to confirm you want to avoid display of just current month value rest should be as it is?

If first is true then AFAIK its not possible to make changes in same chart when another chart type is selected, not sure though as of now, will give it a try.

[raadwiptec]

hi dig vijay it is not the same chart..iam using the the data from script to make another straight table...

[Kushal_Chawda · Accepted solution]

try below expression

= Sum({<Period -={"$(=date(today(),'MMYYYY'))"}>} Quantity)

[raadwiptec]

hi kushal,

how to give multiple conditions in the same expression..as already expression the existing sum

[Kushal_Chawda]

You can do like below

sum({<Period -={"$(=date(today(),'MMYYYY'))"}, Field1={'a'},Field2={'3'}>} Quantity)