Total presentation in Pivot Table

[tyagishaila]

Hi All,

I need to show total in pivot table, as in screenshot.

i.e. Total based on LFL column must placed 1 after another in a single column.

How can I achieve this, please help me out.

Thanks,

[Gysbert_Wassenaar]

That can't be done in a pivot table. Your screenshot also doesn't show a pivot table. Qlikview is not a spreadsheet application. Insisting on using it as one will be a very frustrating experience.

[MK_QSL]

How IntervalMatch Solved My Profit and Loss Dilemma

You need to create report something like this...

[tyagishaila]

I attached excel sheet that created by our department. We are creating this report by qlikview,

that department need, Total must show in the same way.

I did it by create new dimension value like Total-NCR with where condition and concatenate it with field LFL.

Total is showing okay, but performance is getting down, may be because of  concatenate column values for Total increase the size of data.

[prashantbaste]

Hi

As per my understandings after looking at your que & attached screenshot what I can suggest is this can be achieved  by making some changes in your model -

Map store code (or other fields as per requirements) with your desired Total field names & add those in chart can help you to show Total field.

Hope this will be helpful for you.

--

Regards,

Prashant P Baste