I created a pivot with Service Receive YearMonth and Service Paid Year Month as Dimension and Service Allowed Amount as Measure and I got as follows.
But I am expecting a Triangle like below:
Note: As per data above in the Service Receive Date of Jan , Service Paid Date in January 01/09/2017 and 1/28/2017 and the total amount in January 143+123 = 266 (around) . Service Paid in Feb for Jan service Year is 339+300 = 639 (around).
But I am not getting the expected result . The second Picture is correct one . The first one is done by Pivot Table with Two dimension and measure as Sum(Service Allowed Amount). I think I have made some where wrong. Please advice.