Hi I have a trouble in adding new member to existing dimension to that in filter selection.
The dimension name is (Workbooks) and the measure is (NO OF clicks ).
I am using trend line chart with Workbooks dimension in the colour shelf - to display every workbook with NO OF clicks
on a particular time period.
There is other chart showing a singular trend line with aggregated measure NO OF Clicks with out Workbooks dimension.
Now i need to have this NO OF Clicks assigned to a new dimension member (Total) so the users have flexibility to filter directly from the(Workbook dimension) filter pane .
i.e When users select total from the filter it will show aggregate values for all Workbooks.
Retrieving data ...