We have created a dashboard using Live Office connection from a Webi Report. The dashboard displays data of materials that are being manufactured in the company for a specific period( month, Quarter etc).
Now I have developed a dashboard for some 10 materials that have been manufactured this month. The values are mapped on (C5:C14).
If in the next month, suppose 15 materials have been manufactured and say that the data has been updated in fields C5 to C19.
My doubt is that, as the mapping are already made on C5 to C14, what happens to the 5 new materials data that has been updated. what if the customer wants to see the previous month data???