Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
How to add a dynamic values to In line Table.
I have Status Table (Database Table) and Measure Table(In Line Table)
In Measure Table It is displaying following values
No of Open Items
No of Closed Items
No of Ongoing Items
No of onhold Items
No of Pending Items
but if user selects id 1 in Status Table then Status_Ids of Id 1 should merge with In line Table Values.
Following Values should show when id 1 is selected
No of Open Items
No of Closed Items
No of Ongoing Items
No of onhold Items
No of Pending Items
Status 1
Status 6
Following Values should show when id 2 is selected
No of Open Items
No of Closed Items
No of Ongoing Items
No of onhold Items
No of Pending Items
Status 2
Status 7
Following Values should show when id 3 is selected
No of Open Items
No of Closed Items
No of Ongoing Items
No of onhold Items
No of Pending Items
Status 3
Status 8
and so on..
How this can be achievable. Could some one please help to resolve this issue Please find attached document for sample file and below is the code used for my app
Measure_Required:
Load * Inline [
Measure
No of Open Items
No of Closed Items
No of Ongoing Items
No of onhold Items
No of Pending Items
];
Test:
LOAD
id,
Status_Id
FROM [lib://DataFiles/In_Line.xlsx]
(ooxml, embedded labels, table is Sheet1);
Thanks,
Satya