I have a table with annual forecast value for each product of each customer.
Below is the example of the data:
|Customer||Product||Start Date||Forecast Value (Annual)|
The start date is different by customer cause the deals were closed in different dates.
I would like to break the annual value by month so I can sum up the monthly value. I tried to blend this table with a calendar table, but still can't break the value.
Can anyone help?
This is a "risky" one. Tableau is about "visualization" and still if you are telling somebody it is not possible in Tableau a genius kid or old fox will appear on the block and will correct you immediately;) but to my best knowledge "distributing" is most often functionality which is available in ETL or planning/forecasting tools.