Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can I show all values of a field in the straight table chart dimension even if specific values of that dimension field are selected? It would be like set analysis in the dimension, where I want to exclude the field Market, i.e. <Market=,>
Try like:
=Concat({<Market=>} Distinct FieldName, ',')
Note: Distinct is your choice/requirement
Say you have Market as Dimension, Expression=Sum(Sales). Now you re-write your expression like: =Sum({<Market=>}Sales)
Your dimension values would not respond to Market selection; you would see all Markets even one is selected.
Thanks. As this is a straight table, instead of summing, I want to list out all the values while excluding Market. So the expression I tried is this:
=({<Market=>} FieldName)
But this is a syntax error. Is there a way to exclude Market in this expression?
For the above scenario, try the below expression
=Sum({1}Sales)
Try like:
=Concat({<Market=>} Distinct FieldName, ',')
Note: Distinct is your choice/requirement
Hi
Write below expression
=Sum({<Market=>}Sales)
And go to presentation tab and hide your expression. hide expression.
Regards
ASHFAQ
If you want that nothing should change the straight table then try =sum({1} FieldName) instead of =sum({<Market=>} FieldName)