
Hello Tableau Community!
I am trying to calculate the adds and losses for our internet products. The information we do have is:
- The Billion period (month/year)
- The Account numbers
- The Product
For instance, Account 500 wasn't billed in January 2024, but was billed in February 2024 so would say that's an "Add"
Vice versa, if an Account was billed in January 2024, but not billed in February 2024, that would be considered a Loss. In this example, those would be accounts 200 and 400.
In summary, we would like to say we have 1 Add and 2 Losses. Does anyone have any thoughts on how I can accomplish this through Tableau?
2 respostas

Hello @Deepak Rai
Thanks for the reply. I tried to perform the calculation you provided, but my results are different. Do you know why that's the case?