CODEWITHSUNDEEP
tableau-apipercentagecumulative-sum
Eden T
Eden T

Reputation: 67

Running percentage calculation in tableau

I have calculated running total as below, when I am trying to calculate running %, it gives wrong values

Quarter Status          
Closed  Closed %    Open    Open%   Total   Total %
Q1  16  21.62        58     78.38   74     100
Q2  29  17.57        119    82.34   148    100
Q3  29               191    100     220    100

% values displayed are actual percentage values of the cell count and not the ones calculated on the running total count

How do I fix this

Expected output:

Quarter Status          
Closed  Closed %    Open    Open%   Total   Total %
Q1  16  21.62162    58  78.37838    74  100
Q2  29  19.59459    119 80.40541    148 100
Q3  29  13.18182    191 86.81818    220 100

I have tried % total all options

Upvotes: 1

Views: 262

Answers (1)

Andy TAR Sols
Andy TAR Sols

Reputation: 1735

Have you tried Edit Table Calculation and setting the calculation to restart every [Quarter]? Right click on the table calculation in the view to set different "Compute Using" fields.

Upvotes: 1

Related Questions