🔰 How to make a Dynamic Slicer in Excel, Dynamic Slicer of Metrics in pivot tables

✅ Use the pivot table segmenter and create dynamic metrics, learn how to create Measures in Power Pivot.
We are going to elaborate several metrics for example: Sales, Costs, gross profit and % Gross Profit, we will calculate these with a measure within the Power Pivot environment, we will add a table with said metrics, we will add a segmenter.
Pressing the button will change the metric dynamically, useful for our reports, Dashboard or any other report.
#Excel #LoganExcel #pivottables
🔴 Subscribe 👉 / @loganexcel
📃 Download File
📌Related Videos
✅ Daily TD Report and icon set • 🔺 Reporte diario con T...
✅Current VS Month Prev • Comparar periodos en T...
⏱️ Timestamps ⏱️
00:50 Database
01:47 How to use Power Pivot
03:41 Create gross profit measure in power pivot
07:00 Create Pivot Table from power pivot
08:29 Create headers table (Metrics)
09:10 Add Metrics data slicer
09:43 HASONEVALUE and VALUES FUNCTIONS in Power Pivot
11:26 SWITCH function in Power Pivot
Also follow me on my Networks 📲:
🔹Facebook / logan-excel-1008353283...
🔹Blog loganexcel.word...
🔹Instagram www.instagram....