topic Pivot table in App Development

Pivot table

KevSan — Mon, 24 Jan 2022 14:31:20 GMT

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?

Re: Pivot table

SBDataspark — Fri, 04 Mar 2022 10:22:03 GMT

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.

Re: Pivot table

KevSan — Fri, 04 Mar 2022 08:43:17 GMT

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

or just the formula maybe?

Re: Pivot table

SBDataspark — Fri, 04 Mar 2022 10:21:30 GMT

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