Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I've a pivot table with 5 dimensions and one expression ( # of Hours). The Client is asking me to filter the result of the pivot table whatever he wants by the number of Hours.
E.g.
They want clicking the column header and writing " >3" in order to show only the records who have more than 3 hours.
The problem is that the expression column cannot be checked as Searchable on a Pivot Table.
I know, that i can switch from a Pivot Table to a Simple Table, and this would be resolved, but it would result losing the parcial totals by one of my dimensions.
Any idea how it can be solved?
Thanks a lot.
Albert.
Maybe an inbox would be the best option.
Maybe an inbox would be the best option.
Try to use an input box
Easy and fast. Thank you very much both of you.
Regards,
Albert.