my requirement is bit different than your solution which is implemented on your workbook.
i need to show numbers along with sparklines but columns are values in database not dimensions.
Challenge is i need trendline for multiple quarter based on user selection and i need number for only one selected quarter.
I need sparkline and number only in one worksheet
Do you happen to have a packaged workbook you can post? Please use dummy data if there is anything sensitive. Being able to see the structure of the data and what you are trying to accomplish would be very helpful in answering this question. Thanks!
This is a great solution! One quick question, is there a way to show grand totals for the discrete fields (i.e. Grand Total for Total Sales). Along those same lines, can you create a discrete % of Total for Total Sales by category?
I was able to build out a % of Total for Total sales... but it doesn't add to 100%.. not sure why.