I have a trend chart with dimension Region and week.
My expression is sum(volume). In this chart I am geeting trend lines for each selected region.
I need one more line for showing Nation wise volume.
Is there any way to implement this option ?
In my fact table is Physician level.
column are Physician_Name,Volume, Week.
In my dimension table columns are
Values like this
Please give me your ideas....