Hi, I'm new to Flexmonster Pivot Table. My use case is somewhat similar to a pivot table, but my data is slightly different. I just want to check if Flexmonster will support my specific requirements with minimal changes to my database design or with no changes at all
Region Dimension taxo table
id name parentid
1 Global null
2 America 1
3 NorthAmerica 2
Product Dimension taxo table
id name parentid
1 Equaties null
2 cashEquaties 1
3 FX 2
4 derivatives 2
like i have multiple dimension
my data for able dimension in different table something like below
Region Product value
2 3 10
2 4 20
if i want to use pivot table how can prepare my data
Hello, Hari!
Thank you for writing to us.
Here is how you can prepare your data for Flexmonster without database design changes:
JOIN
clauses based on ID columns and include the readable names from different tables based on IDs.Please let us know if you need any further assistance.
Best Regards,
Maksym
Hello, Hari!
Hope you are doing well.
We are wondering if you could connect your data to Flexmonster.
Please let us know if you need any further assistance.
Best Regards,
Maksym