Excel Dynamic Reports Stand for
What is Static and Dynamic Data?
Static is data that doesn’t change. Dynamic is data that does change.
How about an easy example? Consider a company that keeps track of its customers. It keeps a list of those customers in a certain spot. That’s dynamic data – it changes all the time, as customers are added, deleted, and updated. But, on each customer form, there’s a spot where you can pick what industry they’re in – Agriculture, Financial, Automotive, etc. The options AVAILABLE in that list are considered static data. You see these lists everywhere – choose the country you live in, choose your district, etc., on forms you fill out. Those lists are static data. We aren’t exactly changing the list of district in the Bangladesh, It’s static.
What is Dynamic Report?
Dynamic reporting is nothing but adding dynamic expressions, dimensions and data source. We can create a dynamic reports using formulas, dynamic name ranges, data links etc.
Now, may be you have a question, why I create a dynamic report when I’m able to create each of the report. Yes, you are. But isn’t smart working is better than hard working? This is the main reason for creating a dynamic report which helps you to create other reports easily and efficiently without effort and wasting time.
For an example, you prepare a report where you store your respective data in date wise. Now you want this data in Weekly, Monthly, Quarterly and Yearly. You prepare each of the report separately? Definitely no. So, lets do it….