Good Morning,
I created a data-model and wanted to add a measure for gross margin based on two tables and have that calculate on my modeled pivot table (Grouped by a date range on columns and order numbers/categories on rows). When I did create the measure I got an error (img attached) about a single value for column X cannot be determined.
Can I get some help on how to create the GM field for the modeled pivot table? I thought maybe a calculated column but that option is grayed out.
Ideas?
Measure1.png
Measure2.png
Measure3.png
Thank ya kindly good people.
Bookmarks