"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

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Watch MrExcel Video

Forum statistics

Threads
1,108,522
Messages
5,523,363
Members
409,514
Latest member
MarkZuckerberg

This Week's Hot Topics

Top