🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Creating dynamic columns using aggregation filters

Francesco Arena asked on January 3, 2020

Hi, is it possible to create dynamic columns using filters to aggregate data?
For example, I have 5 types of rooms, I want to generate the column containing the availability of:
All type of room; 
double and quadruple rooms; 
suites ans Single room;
suites and Appartments.

All room  |  double+quadruple| Suite+Single |  App.      |
10          |   4                       |   2                |   4          |

1 answer

Illia Yatsyshyn Illia Yatsyshyn Flexmonster January 6, 2020

Hello, Francesco,
Thank you for your question.
In case the desired data set contains only available rooms, the desired functionality can be achieved by creating the calculated value based on the count aggregation of the field, representing the type of the room. Please check out an example demonstrating such an approach.
If the data set you want to display contains both available and booked rooms, we can recommend adding the calculated value based on the formula with condition. Such an approach requires the presence of a property that would represent the availability of the room within each member.
More information about calculated values can be found following the link: Calculated Values.

Please login or Register to Submit Answer