i have struck one place please give me any suggesion to come out from that.
My requierment is i have one Division , Sector Fields.
in sector field these are values:: XY
YZ
In Division Field these are Values::
areoplanespears
autospears
domestic
international
unitdivision
In the Chart i have to show the Divisionn values like below and in the first expression current date selection and second expression from month start to current date(suppose if we select Nov 25 in the second exp should be display 1-Nov-2014 to 25-Nov-2014 data ).
Header 1
Header 2
Header 3
Header 4
Header 5
Division
Sector
Sum (ales)
at current date(i mean current selection)
sum(sales)
From-monthstart - Currentdate selection
XY areoplanespears
Values
Values
XY autospears
Values
Values
XY domestic
Values
Values
XY international
Values
Values
XY unitdivision
Values
Values
XY all(areoplanespears,
international)
Values
Values
YZ all(unitdivision)
Values
Values
XY all means what are the Division values is related to XY sector those need to display like YZ also.
In the First exp we have to display the current selection value and second expression from month starting to currentselection data only.
Thanks for replying but in stright table Division field need to be maintain one extra value that XYALL like areoplanespears,Gio Spares...etc XYALL field comeing from after combin the international and areoplanespears values because international and areoplanespears these values sector is XY.
