more excel

sum of margins if add to pivot directly
it adds the answers before converted to percentages?? which is bad
calculated fields waits for others to aggreggate first so we dont keep adding up on last column??
video5

conditional formatting exclude grand total by checking the higher filter level with more names if want to see bar proportions

colour scales for percentage anomalies goes up from 0 to 100

if you want a non static drag to fill uncheck getpivotdata in options under analyse

reference from outside dont update if column switch with rows. only updates with adding columns or rows in same directiond

if drag dont work but empty copy paste directly better with absplutes or mixed refs

you can turn off autofit in pivot table otherwise ####

pivots cant add columns for mo reason for cleaner whitespace

add ifs all*** if dif specific categories or strings breaks the flow so no (ALL). even if age brackets are contiguous because its not continuous.  just clicking the all filter wont work
try referencing it directly like
IF($H$3="(All)", "*",$H$3))

if numeric values  split in
IF($H$3="(All)", ">0",$H$3))

no calculated fields for data model multiple tables for pivot

0 (Zero) is shown instead of the expected result.

Make sure Criteria1,2 are in quotation marks if you are testing for text values, like a person's name.

data model automatocally populates rest of rows wiyh just one cell to align woth other columns. no need to drag

on data model diagram
The asterisk identifies the many side; the 1 identifies the one side.

summarize value field key by aka aggregation
distinctcount how many repeats of numerical combinations like types of serial keys bought

qualified means  including thr specif ic worksheet or table name before axtual data