Pivot Table

[nareshthavidishetty]

Hi, can any one please create a pivot table using attached sample excel data..

[sunny_talwar]

You have three tabs in there? What is your expected output?

[Anonymous]

hi naresh,

Make a pivot table and drag the specific dimension on the header.

Thanks & Regards

Neetha

[nareshthavidishetty]

I need city wise type1,type tech and type name sales as every type has different expression

type

[Anonymous]

Please elaborate more on your requirement,what are the expressions for each type

[mazacini]

As other posters have indicated, you need to be more specific.

There are a variety of pivot options available from the information you have provided.

Here is one.

[qlikviewwizard]

Hi,

Please check the attached app.

[nagarjuna_kotha]

Can u tell me what exactly output you are looking for ?

[pratap6699]

concatinate the tables with renaming the values and valuble to value... then take pivot table dim-->city,techtype,type1,typename exp-->sum(value)