Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In My QV Dashboard Customer Wise Category Show When ((Total Weight/TotalSale)*100)>90 then Silver,When >100 then Gold, When >110 Then Diamond Where Total Sales retrieve on excel And Total Weight Retrieve on Database We Want To give Filter When Select Gold Then Show Only Gold entries when select silver then show only silver entries when select diamond then show oly diamond entries if select doesn't anything then show all customer Please Help..... Attached Qv IS Given Bellow
I personally would set the equation ((Total Weight/TotalSale)*100)) as a field then create a range and use that as it creates a field you can filter on and add into tables
RangeName:
LOAD * INLINE [
Band, From, To
Silver, 90, 100
Gold, 101, 110
Diamond, 111, 500
];
Inner Join IntervalMatch([Equation Field]) LOAD From, To resident RangeName;
Left join (Table)
LOAD
[Equation Field],
Band
Resident RangeName;
Others may have more elegant ways to achieve it.