Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Sunny,
See the screenshot as we see currently i am getting Total for both the dimensions:
Actual output i am getting:
Expected output:
But you initially mentioned that you wanted the year? I am somewhat confused
Sorry for the confusion
That was the main requirement but if you see this one also one off the issue in the headers.
For total coming twice you can use Year as Dimension.
PFA
Cheers,
Pankaj