Hello Tableau Community!
I am working on a report where I am trying to show the number of total # adds and losses across our internet product offerings (different tiered internet speeds). For example, we want to be able to say that we had X amount of 'losses' and Y amount of 'adds' by internet speed in a given month.
To accomplish this, I've set up a table calculation where if an account wasn't billed in February, but it was billed in March, it would be considered an "add". Vice versa, if it was billed in February, but not in March, then it would be considered a "loss".
Now I need to calculate the sum of "adds" and also "losses". Does anyone know of a calculation I can use to accomplish this?
Here are screenshots from my Viz's.
Please let me know if I can help provide any further clarification. Thanks in advance for the help.
Just do Window_Sum, That can be said without workbook. Please attach an example workbook with fake data so that you can be helped.
