Pivot table Total issue

[sanket94]

Hi,

   I am trying to total up by the date and not the total of entire data.  For example, attached :

Sum of Counts:5989 

If I use total formula it takes: 2277480

Percent shows up as 0.3%

But I want to use 

Sum of counts:5989

Total should be using: 71167

The correct percentage should be 8% 

.

Could someone help me with this? Thank you in advance.

[Vegar]

Your total calculation will give you the grand total on all rows. You'll need to include your row dimension while calculating the total.

I assume your total calculation looks similar to this

Sim(total Counts)

You will  need to change it to  something like this

Sum(total <add_date> Counts)

[sanket94]

I need to select add_date to give take a total of that particular date. But when no add_date is selected it takes grand total.

Eg when I select add_date as Nov 19th it will turn to 8 percent. But when I don't select it goes to 0.3%

I am trying to show the percentage using totals of add_date. ( Without the selection of add_date should show 8%)