You could use a conditional show based on the number of possible values.
Firstly you would have a table, or pivot, with Product in the dimension list and an expression like this:
=sum({<Date={'$(=today())'}>}Sales)
And on this chart you would have a Show Condition and Calculation Condition of:
=GetPossibleCount(Sales) > 1
You can then make a copy of this chart (so it is exactly the same size and position as the first chart) and make the following changes.
On the dimensions remove Product and add Date as a dimension.
Change the expression to read:
=sum(Sales).
Change the Show Condition and Calculation Condition to be:
=GetPossibleCount(Sales) = 1
That should give you what you are after. From a UI perspective the images uploaded by Nag Aviral are fine.
I often swap from a table view listing many items (such as products) to a number of objects showing details for many products when there is only one product available. Almost the opposite of what you are asking to do here.
Hope that helps.
Steve
