Good day,

I can not get power pivot to accept cells in a relationship when I have a new branch in the following financial year without loosing visibility of the previous.

Also I see when creating a pivot table for the matching relationship data only provides me with the column header it removes the Month and the Financial Year it is relevant to.

​Good day, I can not get power pivot to accept cells in a relationship when I have a new branch in the following financial year without loosing visibility of the previous. Also I see when creating a pivot table for the matching relationship data only provides me with the column header it removes the Month and the Financial Year it is relevant to.  Read More

​