Here is the simplest method we have discovered so far: 1) Duplicate the field as a slicer AND a report filterįirst step is to take the field you want to use as a slicer, and add it to your pivot both as a slicer, and as a report filter, as in this simple pivot:ĭate Field Dragged to Both Slicer and Report Filter 2) Observe that the Report Filter “Tracks” the Slicer Sometimes, you just want to grab a slicer’s selected value and use it in an Excel formula, right there in the sheet. That’s a very useful trick, one that we employ all the time at Pivotstream.īut sometimes, that is overkill. The new technique is much less hassle.īack in June, Kasper posted a trick which lets you detect a user’s selection in a slicer, and use that in a PowerPivot measure. ***UPDATE: An even better technique is now posted here.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |