Good morning all!
I have the below load script and it loads all well and I can make charts etc. However, when I try to create a listbox with the inline table (%pickmetric, %metric), I cannot see this option in listbox. I can see in the data model all three tables and there is data island created for the third table and the first two tables connected to each other. Any help is appreciated.
set hideprefix = '%';
CC as CostCentre,
[CC Description] as CostCentreUnit,
AC as JobNo,
[AC Description] as JobTitle,
pick(match(Period, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12), 'Apr-16', 'May-16', 'Jun-16', 'Jul-16', 'Aug-16', 'Sep-16', 'Oct-16', 'Nov-16', 'Dec-16', 'Jan-17', 'Feb-17', 'Mar-17') as Month,
LOAD * INLINE [
[Staffing Mapping Table.xlsx]
(ooxml, embedded labels, table is Sheet1);