I've just known about this site and It is great! Thank you for your work.
How could I get from other sheet's pivot table values with a certain text in a field?
I mean, i have a pivot table showing 2 columns:
Concept | Amount
I want to get to my dashboard SUM of amount for concepts containing word "(upsell)".
Also to get only minus signed values from amount column would be appreciated.
Thank you in advance