Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I am working on creation of Pivot table in Excel template in Nprinting november 2017.
I have 10 dimensions and 1 measure . I created the table with the this details in Qliksense and pulled it into nprinting table node in excel template.
added all this columns into excel sheet1 and create the formula as below.
Offset(sheet1!$A$1,0,0,CountA(Sheet1!$K:$K),11)
Then I clicked on Insert tab in the excel ribbon and clicked on Pivot table.
Given the table/Range value as "Pivot" --> this is the name i given to the above created formula. and given Ok to create the pivot table in new sheet.
In the Pivot table sheet, I dragged the measure into values box. I tried to convert the aggregation function to Sum but it is showing the following error.
My main requirement is , I need to get the pivot table for the dynamic range of data. That is the reason i created the range formula with offset function.
Below is the error.
Please help to resolve this issue.
Regards
srinivas
Got the solution. Just need to uncheck the option "Add this data to the data model" in Create Pivot Table window. Then user can select the aggregated function
Regards
Srinivas