I cannot figure this out, i've search through the web countless hours now, with no luck.
i have 3 tables, which i've added to a data model in PowerPivot, and i have created relationships. But when I make a pivot table, on several of the columns genereated it shows the grand total for a column on the rows.
Udklip.PNG
Attached Excel Workbook as well.
Bookmarks