How to make a table by comparing the monthly management fee horizontally and vertically?

Horizontal generally refers to the comparison with the property management fee in the same lot. Vertically, you compare yourself with yourself, including ring comparison, cumulative year-on-year, ring comparison and ring comparison.

Horizontal comparison is generally the comparison of unit price, while vertical comparison is generally the payment amount, because the unit price is fixed. Moreover, this contrast is meaningless to the owners or tenants, and is useful to the property management company. The management fee is directly related to the vacancy rate of the property. So I answer the question from the perspective of a property management company.

Property management fees are divided into payable and paid, and the two should be compared vertically. Table style, suggestions are as follows.

Year, month, property name, month, month, month and month.

20 15 1 1 real estate 1 55 50

20 15 12 real estate 1 55 60

So recorded. When doing vertical comparative analysis, select all the titles and data, insert and pivot table, and you can add up the management fees of all the properties in each period, and make two pivot tables to compare the values.

Because there is no excel in the phone, you can't take a screenshot. If you don't know, please see the screenshot and ask me.