create pivot table without field in column or without field in rows, comparing to Excel

Webix JS
1

i need to create a table without dropping any field in columns or in rows. Comparing to EXCEL even if any field is chosen for rows or column, it still calculate and show a result. I seems like pivot chart can do but not pivot table

2

Please post some example or picture. The explanation is not clear to me.

3

creating pivot without field in rows : http://devfree.byethost9.com/print_scr/pivot_without_field_in_row.png

Result : Pivot table does not show result but pivot chart shows the right result compare to Excel. http://devfree.byethost9.com/print_scr/pivot_without_field_row_result.png

Excel pivot without field in rows : http://devfree.byethost9.com/print_scr/Excel_pivot_without_field_in_rows.png

4

Hello,

Pivot should have at least one row selected.

And we are going to implement total calculation:

  • totalColumn - sum of all cells in each row

  • footer - sum of all cells in each column.

If you need to get this solution ASAP, please open a ticket in Member area.

5

Oups !!! i was testing WEBIX to see if it can really help for full pivot table before purchasing the license. It is far from this solution which is almost complete but not enough designed for web (http://webpivottable.com)

6

Sorry, but you are comparing different kinds of products.

Web Pivot Table is a fully functional pivot, but it had predefined UI and small API. It is more a full app than a widget.

Webix Pivot is a pivot widget, that has very rich API and every aspect of UI can be customized.

If you don’t mind to use the exactly same UI and functionality as a demo at web pivot table site has, it will be a better choice in your case.

If you need a pivot widget to place in your app, and configure it to look and behave as necessary for your business process, Webix Pivot will be a better choice.

7

Thanks Maksim for your answer, Webix still be the best solution because i want to place it in an existing App.
But if you look at my images, pivot chart shows a good result while pivot table does not show any data

8

Currently, the pivot table expects to have at least one value in “column” and “row” sections to render the pivot.

I will add the above mentioned functionality in our TODO list, so it may be added in one of the next updates.

9

thanks a lot for your support