How to make QS display only 1-30 column only and hide the rest of column ? when i select Aging = 1-30.

[paulyeo11]

Hi All

I have a pivot table , when i select Aging period 1-30 ,

it does able to display the correct 1-30 aging amount , my question is when i do this in QV , it only display 1-30 column.

But in QS it display all column info include 1-30 . 31-60 etc.

How to make QS display only 1-30 column only and hide the rest of column ? when i select Aging = 1-30.

Paul Yeo

[paulyeo11]

Hi All

Enclosed my QVF

[Vasiliy_Beshentsev]

[Vasiliy_Beshentsev · Accepted solution]

OR

if you want display only 1-30 column then do this:

[paulyeo11]

Hi Vasiliy

Thank you very much,

Now i understand why.

So i just create a new field , which is ar_aging_class , which break the aging day in to :-

1-30

31-60 and so on.

and i just using ar_aging_class and it work fine now.

Paul Yeo