Page 1 of 1

Chapter 7, Pg. 68; Pivot Table Results Not Matching

Posted: Sun Apr 28, 2019 10:25 am
by tehstig
Hello,

Pg 68 (of my book) shows the resulting Pivot Table that should be achieved when placing Products[Category] on Rows, Calendar[Is Weekend?] on Columns, and [Total Sales Amount] in Values. Calendar[Is Weekend?] is a calculated column with the OR function given in the prior page.

My table shows up when adding the rows and the columns, but once I add the values, the FALSE and TRUE columns disappear and a "(blank)" column is created instead -- so I'm not getting these same results?

Can anyone help me with why? This must be an error on my part as I did not see someone talking about this specifically yet in this forum.

Is it because Product and Calendar are two different tables, and to filter both would require going "Uphill" to the Calendar table?

Thanks for your help!

Re: Chapter 7, Pg. 68; Pivot Table Results Not Matching

Posted: Mon Jun 24, 2019 8:51 pm
by MattAllington
I realise this is very old, but sorry, I missed it when posted. Do you still have an issue?

Re: Chapter 7, Pg. 68; Pivot Table Results Not Matching

Posted: Wed Jun 26, 2019 3:53 am
by tehstig
Yes, I never figured this out

Re: Chapter 7, Pg. 68; Pivot Table Results Not Matching

Posted: Tue Jul 02, 2019 5:53 pm
by MattAllington
Can you please post your workbook so I can take a look

Re: Chapter 7, Pg. 68; Pivot Table Results Not Matching

Posted: Mon Jan 20, 2020 11:17 pm
by jay
Hi,
I am also getting the same error.