Help needed on Pivot table

[#1]

Dear All,

I have pivot table like

Product  Group	Product  Name	Sales  Qty.	Sales Value	Return  Qty.	Return  Value

it is OK and working properly. Now I Want to change this like 

Product  Group	Product  Name	Sales		Return
		Qty.          Value		Qty.     Value

Please help me to do this.

anilsknp

[#2]

Hi,

To do this, you need to have a dimension like Sales and Return.

Based on the type, the value will be present under the dimension.

Regards,

Srini.

[#3]

hi, Sri

yes I have a field trnType in which 'Sales', 'Return' Is comming but required result is not comming

i am attaching sample QV file

Regards

anilsknp

[#4]

Hello anilsknp,

try to use 'trnType' as a third dimension in your pivot, like anilsknp mentioned above. In your example data is only one value ('Invoice') but take a look at the modified app anyway :

HtH

Roland

[#5]

Dear Sir,

Your sample QV file is exact what I need, but when I am taking the "trnType" as 3rd Dim then result if differ

please tell me that how i can set this field or value of field horizontally

best regards

anilsknp

[#6]

No, I just checked the "trnType" and it has just "Invoice".

I even checked "Source Code", it has Just "SALES".

Please check the data and updated the file.

Regards,

Srini.

[#7]

Hi, Sri

yes this field have only one value that is "Invoice".

Please tell me that how can I use this trnType field as 3rd Dim as Roland used Because when I am using this as 3rd Dim then value of this field showing vertically for this I checked Presentation Tab in Pivot propertie but I cant find any option for it.

Here I am attaching both QV Files

1. Test                      My sample

2. 38138.Test            Roland sample

Well If I can used this trnType Field just like Roland then I got answer of my query.

Thanaks & Regards

anilsknp

[#8]

Hi,

No, what i thought was you can have a new field called "SubTransType".

That field will have only two values i.e., "Sales" and "Returns".

What ever the condition you use here, you can use the same logic in the script for the table.

So, you don't need to calculate that many expressions. Example : if you want Value and Qty then you just need two expressions.

One is sum of Value and next is Sum of Qty.

With the same report, add this new dimension and drag it and drop it horizontally. So you will get the same design of the report.

Regards,

Srini.