Unfortunately, since I now have to create the pivot table/chart from the data model, I can no longer use a calculated field. However, since the data is in two separate tables, I have had to create a relationship between the two tables using the DATE field of the two tables. This would be perfectly straightforward to do if the data were all in one table as I’d just have to use a calculated field in pivot table to calculate this. My aim is to represent Percentage of Total Sales made by Product A broken down by date and since my dashboard is interactive, I’d like to give my user the option of viewing aggregated data for month or years as well using pivot table date grouping. I’ve got another table that has got sales for all of the different products against the dates when these sales were made ( see screenshot of sample data from this table). The table only contains dates where a sale for Product A has been made so there is no record in the table when a sale of product A has not been made.
Within my original excel file, I’ve got a table that has got sales for product A against the date and time of when the sale was made see screenshot of small sample data from this table. The dashboard also contains a slicer that controls ALL charts in the dashboard since all are present and made from the data model. I’m creating an interactive dashboard containing pivot charts for different product sales at my work.
0 kommentar(er)
