cancel
Showing results for 
Search instead for 
Did you mean: 

Pivot Table like excel

Bring the ability to resume a table in other format...summarize, count, etc.

Create new columns in base to source table sum or div, etc

We Need a control that approach to a pivot table performance like in excel... Something...To work with local collections

Status: New
Comments
lyndon
Regular Visitor

This will be really useful!

Anonymous
Not applicable

by any chance any update on this?

 

FabrizioA
New Member

Please, also allow to display custom data, not only sum, count, etc. The best will be allow to create something like a form in the cell to display data.


dcs_CSEM
Regular Visitor

This could be a really neat feature to have indeed !
We miss a way to edit over large table of data and visualize intermediate summaries.
Any update ?

dcs_CSEM
Regular Visitor

I want to add that it is possible to achieve a sort of pivot table with nested galleries. But the max amount of nesting is set to 2.
Three nestings would at least allow us to make group and sub total for row and columns.
See here :
https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Nested-Galleries-Expand-Limit-to-At-Least-3-Nes...
and here : 
https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Remove-nested-galleries-limit/idi-p/465174

Maybe we can use another aproach and use a ClearCollect to format the data source rather than having on the fly calculation in the galleries.