Re: Re: Question on Pivot Table - Page 2 - Qlik Community

Report Inappropriate Content · ‎2014-02-25

Hi All!

I have a question regarding pivot table. I have a table that looks like this:

Now the totals : 1000, 140 and 700 (background is red) should be in the Beginning balance value under the Month Feb-2014

So, I have an excel file which contains only the beginning balance for Jan-2014, The total that is generated from Jan-2014 or the Ending balance should be placed on the Beginning Balance of Feb-2014 and so on. (For example, Feb-2014 ending balance will now go to Mar-2014 beginning balance)

How do I achieve this? Is it possible on Pivot table?

Thanks in advance,

Donna

Report Inappropriate Content · ‎2014-03-03

bump!

Report Inappropriate Content · ‎2014-03-04

bump!

Report Inappropriate Content · ‎2014-03-12

^bump

jonathandienst · ‎2014-03-14

Donna

Can you upload your sample_source.xlsx file to test mods to the load script?

Regards

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

stabben23 · ‎2014-03-14

Hi Donna, something like this?

Report Inappropriate Content · ‎2014-03-14

Hi ! Please see attached.

Report Inappropriate Content · ‎2014-03-14

Hi! Please see attached.

Report Inappropriate Content · ‎2014-03-14

I'm sorry can you explain it a bit further? Thanks!

Report Inappropriate Content · ‎2014-04-02

up

Report Inappropriate Content · ‎2014-04-02

bump