I want to display report in tabular format. I have two dimension (A and B).
I have marked in color code. Amber color will not change it should static and if i select A then corresponding data will display. Similar way for column B.
Output format mentioned in sheet 2
Even, this should work default. I don't think whether you need any changes here
And try BG color for A dimension and try with selection then see ?
Create Flag in your script and use it in your front end
Load Area,Component,A as data,'A' as Flag from table;
Load Area,Component,B as data,'B' as Flag from table;
In front End
take Pivot table
add dimension Area, component
take Filter in front end : Flag
What is the diff between first sheet and second sheet for first three columns?
Can you make it clear in image where we have to look
You can do that in straight table also or in any other chart.
I'm assuming that your table should have Area and Component and 3rd dimension as A or B based upon the user selection.
First load two flags in a script.
load * inline [
Then in front end have a list box/filter with FieldValue
Place a table --> Add dimensions Area, Component and 3rd one should be a calculated dimension
if(GetFieldSelections(FieldValue) = 'ReportBy_A', A,
if(GetFieldSelections(FieldValue) = 'ReportBy_B', B, A)
Then by default your report will show data for A and changes accordingly on selection of B or A.
Try like this
Then create pivot table
and selectas dimensions
and give data as expression
then drag select from vertical to horizintal,
Note:select is a fields name give name with your convenient name.