"What If" slicer in a pivot table with actuals How?

Purplehazed

New Member
Joined
Jul 7, 2014
Messages
7
I have a simple pivot table that categorizes checkingaccount activity like this:
Paycheck 100 100%
Grocery -10 10%
Rent -5 .05%
Gas -5 .05%
Etc…
Total 80 80%
A power query conditional column categorizes the activity likethis;
ContainsEmployer then Paycheck
Contains Krogerthen Grocery
Contains EZ Gasthen Gas
Etc…

I want toadd a slicer than lets me choose “what if” Paycheck amounts
while theother categories remain actual. Thiswould allow me to
see categoryspending percentages at different earning levels.

Thoughts onDAX functions and/or how best to model this scenario would be much appreciated!
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

Watch MrExcel Video

Forum statistics

Threads
1,112,995
Messages
5,543,185
Members
410,584
Latest member
Bluefox68
Top