Pivot table total header names

[hari8088]

Hi All,

I have an issue with pivot table total headers.

Currently i have a povit table with 2 dimension and 3 expression,

I have a requirement where i should drag second dimension into vertical as shown below .

Hear the problem is Total for each year should show for particular year.For example

year 2018 total should be :2018 total

Expected output should be like below

Here are the Sample qvw and expected output files.

stalwar1‌

stevedark‌

theresaa‌

[sunny_talwar]

Unless you share what you have, it would be difficult to know what might be the issue.... or may be someone else have better ideas for you

[pablolabbe]

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others

[hari8088]

Sunny,

See the screenshot as we see currently i am getting Total for both the dimensions:

Actual output i am getting:

Expected output:

[sunny_talwar]

But you initially mentioned that you wanted the year? I am somewhat confused

[hari8088]

‌Sorry for the confusion

That was the main requirement but if you see this one also one off the issue in the headers.

[passionate]

For total coming twice you can use Year as Dimension.

PFA

Cheers,

Pankaj