Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Please find attachment
As per requiremnet I need to show data in pivot table as
Field 2 data=feld 1 data+ field 2 data
Field 3 data=feld 1 data+ field 2 data + Field 3 data
Field 4 data=feld 1 data+ field 2 data + Field 3 data+Field 4 data
Can you please suggest what would be the formula for this
Please find QVW file there are month wise days and on combination of month and day there is count of sales.
I need to show data like
Day1 data data=Day 1 data+ Day 2 data
Day 3 data=Day 1 data+ Day 2 data + Day 3 data
Day 4 data=Day 1 data+ Day 2 data + Day 3 data+Day 4 data
Thanks
Please provide sample data otherwise you can achieve this requirement in the pivot tables.
Please provide data in excel file or in sample apps.
Please provide sample data otherwise you can achieve this requirement in the pivot tables.
Please find QVW file there are month wise days and on combination of month and day there is count of sales.
I need to show data like
Day1 data data=Day 1 data+ Day 2 data
Day 3 data=Day 1 data+ Day 2 data + Day 3 data
Day 4 data=Day 1 data+ Day 2 data + Day 3 data+Day 4 data
thanks
Hi anand,
PFA,Please suggest how to implement same in pivot table.
Thanks
Hi Deepak.
use rangesum(above(sum(Amountfield)),0,rowno(Total)) in expr
see the attched file
hope this helps
Hi Sunil,
Thanks for reply.
Currently my days are not rows I have taken them as a columns for same reason by using formula whatever u have mention I am getting sum for day 1 day2 only .
In this case can u plz suggest how to proceed,
Thanks