Need help with Pivot

[#1]

Hi Folks,

Please help with attachment sample file.

Thanks in advance....

Sub2u

[#2]

see attached doc

[jyothish8807]

Hi Sub2a,

PFA

Regards

KC

[#4]

Hi,

Thanks for your reply..

I am unable to open the file....

Sub2u    

[#5]

Hi,

Thanks for your reply..

I am unable to open the file....

Sub2u   

Need help with Pivot

[#6]

Just create a chart->pivot table

add two dimensions, Descr and Product in that order

then add just one expression as follows

aggr(sum ( Amount),Descr,Product)

after that just drag with the mouse the product (actually click on product without releasing the mouse) on top of the expression (the numeric values) and that's it.

[#7]

Hi,

Thanks again..

Sorry...Its not getting...

Sub2u

[jyothish8807]

This is because you are using a personal edition of Qlikview.

So follow this step.

Create a pivot table, then,

in dimension:

1. Desr

2. Product

in expression:

sum(Amount)

Then say OK.

After this click on desr field on the chart and keep the left mouse pressed and drag it on the top of Amount field.

Regards

KC

[kavita25]

Hi,

Is this you needed??

Regards,

Kavita