topic Re: Pivot Table presentation in Integration, Extension & APIs

Pivot Table presentation

Hemanth458 — Wed, 17 Apr 2019 03:23:52 GMT

I need the visualisation should be like below attachments before quarter and after quarter Table.

Thank you very much in advance.before Quarter TableAfter Quarter Table

Re: Pivot Table presentation

jonathandienst — Wed, 17 Apr 2019 05:59:28 GMT

Your question is rather broad and lacking in detail, so you are unlikely to get much really useful help.

I suggest you post a small qvf file with some sample data representative of your data model and what you have managed to achieve so far for the pivot table. The data does not have to be real, but the model table and field structure should be representative.

Ask specific questions, like how do i get the header structure like that, or how do i get background colours and so on. There is no problem breaking this up into a number of simpler questions for which you are more likely to get help.

Re: Pivot Table presentation

Hemanth458 — Wed, 17 Apr 2019 06:27:13 GMT

My question is how do i get the header structure like Jan-19,Feb-19,March-19 and how do i get background colour

@jonathandienst wrote:
Your question is rather broad and lacking in detail, so you are unlikely to get much really useful help.
I suggest you post a small qvf file with some sample data representative of your data model and what you have managed to achieve so far for the pivot table. The data does not have to be real, but the model table and field structure should be representative.
Ask specific questions, like how do i get the header structure like that, or how do i get background colours and so on. There is no problem breaking this up into a number of simpler questions for which you are more likely to get help.

Re: Pivot Table presentation

miskinmaz — Wed, 17 Apr 2019 06:36:22 GMT

Hi,

You need to develop the whole logic at the backend where you have to create a inline table of headers and this headers will be associated with the measures you want. If you don't want the backened script, you can use valuelist in dimension and measures to create the custom header.

Re: Pivot Table presentation

Hemanth458 — Wed, 17 Apr 2019 08:36:47 GMT

For this i used viz-lib pivot table there i can't find columns like normal pivot table.

Except Headers all things are now working fine right now

Re: Pivot Table presentation

Hemanth458 — Mon, 22 Apr 2019 16:15:11 GMT

How to calculate dynamic column name like Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec after completion of every 3 months it will roll as Quarter and for remaining it will give month names as well as i need to show YearToDate also in a column. Its my exact requirement.