Apr 26 2022 01:16 AM
Apr 26 2022 01:16 AM
Hi all,
I have more than 5 sheets having the same fields i.e. Date and Symbol, the only difference among is the point of occurrence i.e. date, Pivot Table is not allowing me to create relations among due to same fields, please help out.
Apr 26 2022 02:30 AM
Solution@Deleted
Depends on goals. If you'd like to consolidate all data in one PivotTable you may use PivotTable and PivotChart Wizard Excel Pivot Table Multiple Consolidation Ranges (contextures.com)
Apr 26 2022 09:14 AM
I'm really thankful to you, this is the first Pivot I've made just coz of you. With curiosity to make it much smarter have come up with below points;
Please also advice, if can be improved in other ways.
Apr 26 2022 10:18 AM
@Deleted
You may use the same slicer for few PivotTables if they are based on same data source. The rest is not clear for me. Perhaps with data model and DAX measures you may build cross-filtering. But in any case you need to have something in Values, otherwise it doesn't work. With nothing to aggregate you have all values in rows.
Apr 26 2022 02:30 AM
Solution@Deleted
Depends on goals. If you'd like to consolidate all data in one PivotTable you may use PivotTable and PivotChart Wizard Excel Pivot Table Multiple Consolidation Ranges (contextures.com)