I have encountered a problem when I create power pivot table ( same situation in pivot table with relationship function )
I have first table defined as
and second table defined as
and third table
now I have linked State to StateNo in first and second tables
my question is when I draw State (first table) and Branch (second table) in pivot table Row area, it would wrongly show
<SAME THING ABOVE>
it may be fixed only when I draw Rev (third table) into Value area in Pivot, but It just show Branch-1. I want to show all branches in second table because manager need to know who get 0 this month.
when I choose "show items with no data on row" it would show that stupid layout again
it should give me follow display
Branch-2 0 (or blank)
hopefully I have explain clearly.
thanks for instruction.