![]() ![]() For example, we have selected E*trade and TD Ameritrade in our slicer to give our summary table as: If you wish to choose multiple dimensions simultaneously, simply hold the Ctrl key and click on the buttons that you want your pivot table to display. ![]() You will see that the slicer filters the data so that the buy/sell transactions exist in the portfolio only for TD Ameritrade. Now try clicking on one of the buttons in the broker slicer, let's say TD Ameritrade. So this is how your pivot table will look like along with the slicer: Similar to pivot tables, where the table identifies unique items in its row and column-oriented perspective, Slicers list down all the dimensions only once in its box. For example, let's say we select the dimension as a broker. You can choose more than one dimension from all the available dimensions in the dialog box.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |