I'm trying to create a Year,Month and Quater filter using a drop down option in a pivot chart.
When I tired to populate the selected year it is giving the selection but when I opt for clear option then it is replaced by '-' .
Can some one help me to identify the way to replace the '- ' with any default year when you click clear.
Also for Month when nothing is selected then it showing '-'.
Please find the source data and qvw.
Thanks In advance.
You can use getselectedcount().
for E.g. : If(getselectedCount(Year) = 0,Max(Year),Year).
Check if its work for u.
-Vanraj Dinesh Bohra
But the output was showing only one month in display (i.e max month is shown),I think user might be confused if it is showing only month,Can we have any default value if nothing has been selected
I don't understand. You have separate fields for month, year and quarter and you want them to be available like in a drop down using straight table. Could you explain a bit more? May be explain with an example.