Custom Label in Graph Legend

[ambatiuday]

Hello,

I have a dashboard with Region on X-axis and a Calculation as series. The calculation is the % Change over prior Year. Ex: (2008Q4 YTD - 2007Q4 YTD)/2007Q4 YTD. I have dynamically made my report run and it works fine.

The exact requirement that was made is as follows. The graph legend label should display a dynamic value: ex - Closingperiod(Quarter).

I have tried using custom label in the graph legend, but it works only when I set the source type as text.

When I use the source type as a data item value or as a data item label, it returns me a blank. Please let me know if any one has a solution of this. Note: I am flexible on any Cube changes as well.

Thank you,
Mallika