Sub Total in Pivot Table

[#1]

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

[its_anandrjs]

Hi,

You have to represent data some thing like in sample attached

Rgds

Anand

[SunilChauhan]

i dont think above said is possible

u can use something linke this

or someone may help you

[its_anandrjs]

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

[its_anandrjs]

Hi

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

[#6]

Never Say Never

[its_anandrjs]

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

[its_anandrjs]

Hi,

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

Rgds

Anand