Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a forecast table with Forecast by Sales Team By Country
Sales Team 1, US, 20000
Sales Team 2, US,3000
Sales Team 1, Can, 5000
Sales Team 2, Can, 2500
The link is based on concatenating the Sales Team value and country in the forecast table and sales table.
Problem
I don't have sales data yet for Sales Team 2 for Canada so it won't show in my pivot table. How do i get the forecast to show regardless of the sales data?
If the forecast table and the sales table are concatenated into the same table then the forecast data should show up without having sales data. Are all the dimensions in the pivot table defined for the forecast date?
Regards.
the tables are not concatenated, they are linked by a concatenated field in both tables
Concatenate the tables. Try to match as many columns as possible. For example, Forecast Qtr should be matched to the Date field with Q1 being converted to 1/1/2010.
You might be able to do a complex expression or macro, but if you do a little work with the script the chart expression will stay simple.
Regards.