I can't figure out any way to do it within pivot table. If its just a single row you can add a text box next to the pivot table and use this expression within text box, else you have handle this at script level. Might be some can suggest a better way to do it 🙂
You could pull it off by making a calculated dimension that includes all the values for Resort, 'Total' and 'A/B'. Then have the expression behave differently for 'Total' and 'A/B'. It's not a great solution, but it should work. I THINK I have an example somewhere if you need one. I'd just need to find it.
(Edit: Found it. Attached. It's even more complicated than I remembered. Hopefully someone else has a better solution.)
Well, the main thing I don't like about it is that it uses a calculated dimension. In my experience, calculated dimensions really slow down the associated charts. This calculated dimension seems particularly ugly due to the use of concat() in a valuelist(), which might cause problems if there were a large number of Products (perhaps a thousand or more?). QlikView isn't supposed to have a limitation on the size of expressions (the concat will be expanded into the expression, then the results evaluated), but in practice, I vaguely remember problems occurring. Then the expression has to do the same sort of complexity, which will probably slow the chart down any further.
Fortunately, that objection can be solved by making REAL values for the dimension. The attached example does that.
Other than that, it's not too bad, though probably in many cases the additional expressions might be handled through the data model instead of complicated chart expressions, which would be my preference. However, looking at your spreadsheet from the other thread, that seems like it would be complicated at best, and probably less clear than just playing with the expression as in the attached example. So with the modification to use a real dimension instead of a calculated one, yeah, on the surface this looks like a reasonable way to solve your problem.
