I have an excel with many fields it has couple of descriptive fields and 2 value fields ( YearQuarter Target and Qaurter values) is it possible to create a crosstable without modifying the excel?
What it look when in script:
CrossKPIs:
//CrossTable(YEAR,QUARTER)
LOAD
ACTION,
NAME,
DESCRIPTION,
Calculation,
Format,
Target 2020,
Q1,
Q2,
Q3,
Q4,
Target 2021,
Q11,
Q21,
Q31,
Q41,
Time_Frame
Attached example.
