I’ve been asked to create QS (excel exportable) 32 cell table style visual that has unique calculations in most to the cells to show year over year results. I’m finding that I can’t control cell level calcs in table or pivot table visuals. I’d also prefer not to manually create a matrix of 32 individual cells that can’t be exported as a single visual. The business exporting to excel to insert into a power point presentation offline on a monthly basis. Has anyone found a good approach to building this type of visual? Here is a simple graphic that demonstrates what I’m try to build:
| c1 | c2 | c3 | c4 |
r1 | a+b | b+c | d+a |(a+b)+(b+c) |
r2 | a | b | c | a+d |
r3 | d | b-c | d-a | b-a |
Hello @ksonderup Hope this message finds you well!!
If I understands your problem, my suggestion is that you need ensure your input data includes the necessary columns, such as a, b, c, d, etc.
After that, if you want the c1 cell in row r1 to display a + b, simply create a calculated field with that formula and add it to the table.
Please, tell me if its work
Thanks for the reply @lary_andr . looking at my post again it is a bit confusing. columns are a type column let’s say c1=type 1, c2=type 2, c3=type 3, c4 is a total column. r1c1 is value of widgets for type1 based on cost, r1c2 is value of widget for type2 based on cost, r1c3 is value of widget based on market value, r1c4 = r1c1+r1c2 (excludes r1c3). I’ve decided the best way to handle c1,c2,c3 is to write sql to handle these calcs in the dataset into a single field grouped on type however I’m still looking for a way to calc r1c4 (r1c1 + r1c2) and display in r1c4 in the same table.
Hello @ksonderup, I hope you’re doing well! 
Based on your clarification, it seems you’re aiming to create a qs table with unique calculations for most cells, where some values are pre-processed in the dataset and others calculated dynamically within qs. For columns like c1, c2, and c3, the best approach is indeed to handle these calculations in sql within the dataset, grouping them by type to ensure the data is ready for visualisation. For c4, which represents the sum of c1 and c2, you can create a calculated field directly in qs using the formula c4 = c1 + c2. Once the dataset is loaded, you can add c1, c2, c3, and c4 to your table visual. If you encounter challenges with dynamic calculations, an alternative would be to calculate all values, including c4, in sql before loading the dataset into qs, though this might limit future flexibility. Let me know if you need further assistance!
1 Like
Hi @ksonderup
It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.
If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.
Thank you!
Hi @ksonderup
Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
Thank you!