amelia
05-26-2022ETL
Adding a column with no aggregation
Hi Sisense community š I have imported an excel sheet into my elasticube data model and would like to display the columns in the excel sheet in a pivot table in a widget. I do not want to aggregate the values from the Excel sheet using SUM() or COUNT(), but I get an error if I do not do an aggregation.
Attached are screenshots - the column from the excel sheet is how I would like the data to appear on Sisense pivot table, but the column I am seeing on Sisense has different values as it uses the SUM() function.