Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Problem with Pivot Tables.
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.
Thank you.
Regards,
Herbert
HI
Please find the attachements.
I don't know u r lookinf this or not?
-Sathish
Hi,
There doesn't see to be any obvious answer. As you are using it in Totals, but do not want in the pivot columns.
A Workaround could be to keep a straight table instead, and use expressions for closed and declined numbers, and for for the Quote.
Doing it in Pivot table will be difficult. If anyone finds a better way, I will be interested to know that too.
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.
Maybe somebody has a solution for this.
Thanks.
Regards,
Herbert