Hello Tableau Community!
I am trying to Calculate the total quantity (units) of our different products month over month. The calculation would be # of accounts x quantity. An account can have multiple quantities i.e. 1, 2, 5, etc.
The relevant fields include:
- Time period
- Account number
- Quantity
Here is a screenshot of the current Viz I am working on:
The numbers are close but they don't quite match with what I have outside of Tableau. Does anyone have thoughts on what I might need to do?
Thanks in advance for the time.
@Charlie Mouy
Hi, what if you try:
SUM([Si Qty])*COUNTD([Si Acct Nbr])
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
If this post does not work, then attach a dummy excel, where you explain how it is calculated.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
