topic Re: Sub Total in Pivot Table in QlikView

Sub Total in Pivot Table

Tue, 27 Sep 2011 07:24:54 GMT

Hi,

Please find the Attachmant of Excel File.

This Excel Having the two sheets

1)Data

2)Output Needed

Data Sheet Having the Data.

Output Needed Sheet Having the Requirement.

in the Output needed sheet having Yellow Marked Lines check the formula for that total,we need the total like this in "Pivot Table"

Thanks & Regards

Santhosh Kumar G

Re: Sub Total in Pivot Table

its_anandrjs — Tue, 27 Sep 2011 07:43:02 GMT

Hi,

You have to represent data some thing like in sample attached

Rgds

Anand

Re: Sub Total in Pivot Table

SunilChauhan — Tue, 27 Sep 2011 07:50:12 GMT

i dont think above said is possible

u can use something linke this

or someone may help you

Re: Sub Total in Pivot Table

its_anandrjs — Tue, 27 Sep 2011 08:01:06 GMT

Hi,

See the updated attached sample file like this you have to use it,You have to load calculated field for Total Sales, Total Netprofit by the help of Resident load then you are able to show data some thing that you provide.

By this load

Load

Sum(If([Account Name]='Sales',Values)) as TotalSales,

Sum(If([Account Name]='Net Profit',Values)) as TotalNetprofit

Resident Raw;

See the update file

Let me know about this.

HTH

Rgds

Anand

Re: Sub Total in Pivot Table

its_anandrjs — Tue, 27 Sep 2011 08:15:29 GMT

See the update file

By load like this

Load

Sum(If([Account Name]='Sales',Values)) as TotalSales,

Sum(If([Account Name]='Net Profit',Values)) as TotalNetprofit

Resident Raw;

See the update file

Let me know about this.

HTH

Rgds

Anand

Re: Sub Total in Pivot Table

Tue, 27 Sep 2011 08:18:52 GMT

Never Say Never

Re: Sub Total in Pivot Table

its_anandrjs — Tue, 27 Sep 2011 08:57:45 GMT

Hi,

NO problem see next updated file might be you can use like that.

By using this syntax

For Sales

=Sum(If([Account Name]='Sales',Values))

For Net Profit

=Sum(If([Account Name]='Net Profit',Values))

HTH

Rgds

Anand

Re: Sub Total in Pivot Table

its_anandrjs — Tue, 27 Sep 2011 10:00:27 GMT

Hi,

Hope you got correct answer and let me know if not got.

Rgds

Anand