In Pivot Collapsible , Used 2 Dimension calc in row + 2 normal dimension (Same) in column + 2 aggregated measure and 1 normal measure in data , shows empty column for particular state and name.
Dashboard :Pivot_collapsible_3
Report : 2*2*2