Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
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%)