06-22-2016 05:54 PM
Engaged with a client who is into Energy trading, and using PowerPivot, wherein they access most of the report via Excel, one of the functionality which is provided is a search for value with a dimension, the client is also looking for a similar functionality when he is viewing an hiearchical report in SAS VA,
I thought that we had the filters avialable in the report, but some how i couldnt see the same in my report,
Please do guide if i have got it wrong, or any possible approach.
06-23-2016 07:05 AM
Here's my suggestion and I realize there are some issues with this one - but you can figure out a way to overcome them.