![]() This is turning out to be very convenient for the users and they are loving it as it can get them from high-level, right down to the details. This is also connected to the slicers, so when a user chooses a set of options in the slicers, this table shows the exact records that make up those numbers in the charts. Use the Date field instead, and group it by Years and Months. tabular layout with repeat all item labels) that shows further details of each opportunity. The problem is that the field (column) you used in the Rows area uses the TEXT function, so it is a text value that is sorted in alphabetic order. On another sheet I have a pivot table (setup like a table i.e. Users can slice and dice the data using the various slicers made available in the dashboard. ![]() ![]() by Business Unit, Deal Type, Size of TCV, Closing quarter etc. The dashboard consists of a number of charts showing the TCV by various dimensions e.g. I have created a Sales dashboard using pivot tables and slicers.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |