hand_in_texas
New Member
- Joined
- Aug 20, 2018
- Messages
- 1
Afternoon,
I have a pivot table references multiple tables (when creating the pivot table, i chose "add this data to the Data Model"). I have the relationships I need created, but when I go to select calculations to enter a formula and it's grayed out.
I have sales data based of months, and now want to add formulas, like Year over year and some percentages, instead of manually entering into one of the original data tables and its not available.
I also checked add-inns, and i do not have Power Pivot.
Can anyone point me out in the right direction? All the searches i find are about how to make a pivot table off a data model, and i need to create formulas.
Thank you in advanced.
I have a pivot table references multiple tables (when creating the pivot table, i chose "add this data to the Data Model"). I have the relationships I need created, but when I go to select calculations to enter a formula and it's grayed out.
I have sales data based of months, and now want to add formulas, like Year over year and some percentages, instead of manually entering into one of the original data tables and its not available.
I also checked add-inns, and i do not have Power Pivot.
Can anyone point me out in the right direction? All the searches i find are about how to make a pivot table off a data model, and i need to create formulas.
Thank you in advanced.
