I'm really banging my head against the wall here.
I have been trying to do a crosstab format for a stacked column chart on a dashboard. I'm trying all sorts of combinations and no matter what I do the result shows up as N/A (though it works in the Excel model when exported).
=MATCH(BY7,$BW$7:$BW$158,0) where BY7 is a hardcoded value
what's most irritating though is I have a dashboard doing nearly the exact same thing and it does work.
Also, how am I suposed to populate crosstab style tables in Xcelsius for stacked column charts ifvlookup/match/index are not recommended? Any advice gratefully received.
Edited by: Jeanne Chapple on Jun 4, 2010 7:04 PM