Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
can you provide us sample input data???
Regards,
Prashant
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 ?
I don't required color. Just wanted to show in sheet 2 format
Hi,
Create Flag in your script and use it in your front end
for example
Load Area,Component,A as data,'A' as Flag from table;
concatenate
Load Area,Component,B as data,'B' as Flag from table;
In front End
take Pivot table
add dimension Area, component
Expression only(data)
take Filter in front end : Flag
Regards,
Can anyone help me with attached sample data.
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.
FieldSelection:
load * inline [
FieldValue
ReportBy_A
ReportBy_B
];
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.
Thanks,
Prashanth.
Try like this
crosstable(select,data,2)
load
Area,
Component,
A,
B
from book1.xlsx;
Then create pivot table
Give
Area,
Component,
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.
I have added sample data and screenshot as an attachment