topic Re: How to make QS display only 1-30 column only and hide the rest of column ? when i select Aging = 1-30. in App Development

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

paulyeo11 — Mon, 15 May 2017 04:07:27 GMT

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 — Mon, 15 May 2017 04:08:22 GMT

Hi All

Enclosed my QVF

Vasiliy_Beshentsev — Mon, 15 May 2017 13:46:23 GMT

Vasiliy_Beshentsev — Mon, 15 May 2017 13:48:21 GMT

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

paulyeo11 — Tue, 16 May 2017 00:49:20 GMT

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