Hi,
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
Nation, Region_ID,Physician_Name
Values like this
'Nation','RG01','Sathyan'
'Nation','RG02','Madhu'
"Nation','RG02','Naseer'
Please give me your ideas....
Regards,
Sibin Jacob.C
