Problemdescription: This is only an example: I have a Pivot Table with 2 data colums "Name" and "Status" which represents how many of the projects were declined or closed the the total sum of the Status for each Name. At the end I have inserted a new colum a quote. But there is the problem. It makes also 2 extra colums for each status, and this is very annoying, I don't need them and they are wrong ==> red colums.
Prefered Solution: I would like to get a Pivot Table with the quote colum only at the end at the right side, and I don't need the red coloured colums (delete them)
I hope somebody could help me. For the solutions please use my attached .qvw file.
The solution from Kumar is not that what I am searching for, I attached a better explanation into my .qvw file, so I think it gets clearer my problem.
What I like as solution is the exact same representation in the pivot table only without the red coloured ones, they are wrong and annoying.
I need the total sum column because if not I only get the representation of the "diclined" in the field "Status". And I need Pivot Table and not Straight Table in my real application.
The quote column should be connectet only to the 1 column with the Name, the Status is only a represation of how I get to the quote, but I also need to represent them within the Pivot Table but it should have no connection with the Quote Column at the end. It is tricky.
