1. Go to Analysis -> Table Layout -> Advanced and make the change as shown in the screenshot.
2. Its not feasible, because one row on this crosstab may correspond to multiple products. Tool tip works with only one single value per variable. It will just show a * when there are multiple product names per row (which will be the case in most rows obviously )
3. Its shown in the screenshot above, is this what you are trying to achieve?
1. Thanks for your help was able to the 1st fix worked
2. I understand that it cant be done may be i will take use of Viz in tooltip etc.
3. Yes this somewhat i want, however the bars in your screenshot look very tiny and users might not be able to get the info easily, can these be made bigger ?
Actually the length of the bars is based on the data and its range. For a few rows the value is as high as 20,000$ and for others a few $s.
You can add mark label on the right to indicate the value to the user.
Thanks Anisha, How should i add the bars for the measure ?
Just move SUM([Sales]) to Columns as a measure (screenshot shared in previous reply)
If a reply assists in resolving your query, please mark it as the correct answer. If a reply is helpful, please mark it as helpful.
Hope you are doing well, even though as per my original question you gave me the right resolution however i have to show the days of delay for the for let say each order in the table, each order has a distinct number of days to be displayed e.g. see below .
OrderNo Product Days Delay 1 A 10 2 B 23 33 C 44 44 B 74
i cannot aggregate the days, just need to show them as bars and then sort from highest to lowest, Am i making any sense ?
Please share a sample workbook for this problem statement.