Calculated Field Question

tableaucommunity@tableau.com — Mon, 30 Jul 2012 09:25:08 GMT

Hi all,

I am new to Tableau so forgive me if this is an easy question! I have a large dataset but the following is simplified to illustrate my question. I have 3 columns of data:

Number Payments: 0, 1, 2, 3

Number Active: 100, 90, 80, 70

Number Lapsed: 10, 20, 30, 40

All I am trying to do is to calculate the % Lapsed of the total by payment. The total is calculated by adding Number Active + Number Lapsed at Payment 0 so in this case it should be 110. The %Lapsed therefore would be 18% at payment 1, 27% at payment 2, 36% at payment 3. In Excel I would just absolute the sum of active and lapsed at payment 0 to calculate the %.

It shouldn't be that difficult so I am missing something obvious.

Any suggestions would be appreciated!

Many thanks.

Content in Tableau Community Forums

Calculated Field Question