I have created a filter using a dimension which has - Yesterday, Last Week, Last Month.
I have a chart object, need to write in .. Yesterday/Last Week/Last Month Sales . So If I click on "Last Week" , the chart object label should be "Last Week Sales" ...
how can i achieve that?
May be like this:
=CreatedFilterField & ' Sales'
hey you are rite., i know this, didnt think of it just now! thanks you and all of you!!
try label expression: = YourDimension &' Sales'
Put your dimension field in "Label" under Expressions tab like:
either you create the label Expression as suggested by stalwar1 & tresesco or
Create the Inline Load
LOAD * INLINE [
Last week, Last Week Sales
Monthly, Monthly Sales
Daily, Daily Sales ];
Now in Expression Label just call the Field Label
Retrieving data ...