teh bunneh
New Member
- Joined
- May 19, 2011
- Messages
- 7
Hello! I just discovered MrExcel and I'm finding it very helpful so far. Thanks for creating a great community! I've got a question that I didn't see addressed elsewhere.
I'm building a pivot table using PowerPivot. I'd like to be able to insert Values that don't use any of the pre-built functions (Sum, Count, Min, Max, or Average). I'd just like the cells to display either "1" (true) or "0" (false) without doing any calculations on those numbers. For this table I'm building, "1" and "0" are meaningful numbers, but "27286" is not.
Thanks!
I'm building a pivot table using PowerPivot. I'd like to be able to insert Values that don't use any of the pre-built functions (Sum, Count, Min, Max, or Average). I'd just like the cells to display either "1" (true) or "0" (false) without doing any calculations on those numbers. For this table I'm building, "1" and "0" are meaningful numbers, but "27286" is not.
Thanks!
