Total Up

[upaliwije]

Hi Friends

I have in my QV doc the following Pivot table of course prepared with help of you.

I want to modify this report show subtotal then the days total and grand total. My requirement is shown below

If this is possible kindly advise me how to do it. I also attach sample QV doc H/w

[Anil_Babu_Samineni · Accepted solution]

May be this?

=If(DUE_DATE <= Max(TOTAL DUE_DATE)-1, 'Total Upto 21-Aug-2017', Date(DUE_DATE,'DD-MMM-YY'))

[kaushiknsolanki]

Try this.

It will allow you to set the date.

Regards,

Kaushik Solanki

[upaliwije]

Hi Anil,

Thanks a  lot for your reply. I want a little thing clarified

=If(DUE_DATE <= Max(TOTAL DUE_DATE)-1, 'Total Upto 21-Aug-2017', Date(DUE_DATE,'DD-MMM-YY'))

The above expression works well but since "Total Upto 21-Aug-2017" is hard coded It wont change with selection of due date

I have modified the expression but it does not work

=If(DUE_DATE <= Max(TOTAL DUE_DATE)-1, 'Total Upto'&max(DUE_DATE), Date(DUE_DATE,'DD-MMM-YY'))

Pls correct my expression

[Anil_Babu_Samineni]

I am sorry, I can't help y due to traveling till Tuesday.. May be offer you

[tresesco]

Try with total keyword, like:

..'Total Upto'& Date(max(total DUE_DATE)-1)..

[upaliwije]

It works

=If(DUE_DATE <= Max(TOTAL DUE_DATE)-1, 'Total Upto'&'-'& date(max(TOTAL DUE_DATE,'DD-MMM-YY')-1), Date(DUE_DATE,'DD-MMM-YY'))

only thing date appear as

Total Upto-8/20/2017

I want it to be

Total Upto-20-Aug-2017

Pls help

[tresesco]

Use format code in date() like:

..'Total Upto'& Date(max(total DUE_DATE)-1, 'DD-MMM-YYYY')..

[upaliwije]

Thanks It works

[upaliwije]

Sorry,

Look forward to your help after your travel