Table box it will display the data according to Variable values .
Hi All,
I have a table box in that detailed data is there.
In script side I have created range table here 1 Month, 3 Months, 5 Months, 26 weeks, 52 week are there.
In UI side I have created one variable and pass the values 1 for 1 Month, 2 for 3 Months, 3 for 5 Months...
I have KPI's and Line chart , Bar chart and Table box is there.
In drop down filter and Single value selection point use Variable input.
and use the logic in Line chart and KPI's and Bar chart If (var=1, Sum({<Range={"1 Month'}>}sales) ...
it is working fine for all metrics, But table box it is not working.
Please help on that.
Single selection and Default value shows in reports point used the Variable input why because here 20 sheets are there, every sheet have different range filters are there.
