Pivot table

[KevSan]

Hi everybody,

I need to use a pivot table to show the remaining amount of holidays month by month for selected year... This is not complicated... but...

I also need to show in this table a unique initial amount calculated by the remaining of last year and a particular amount handled by a field. 

How can I do this? 

Can someone please help me?

[SBDataspark]

Hi there KevSan,

I came across your question and have a suggestion that I use to add "fixed columns" to a pivot table.
You can find it in the attached QVF.
This is an adjusted QVF for another community question, but gives you an idea of how you can use this little "trick" in your situation.
The result is this:

Kind regards,

Sebb.

[KevSan]

Hi @SBDataspark , thanks for your answer. Do you have a QVD file please ?

or just the formula maybe?

[SBDataspark]

Hi @KevSan,

There's an example attached to my initial answer...😀
It's not just a formula you need to adjust your load script and be creative in that.
Just have a look at the example and let me know if you need some more help with it.

Kind regards,

Sebb