Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
This is my dummy data.
Service ReceivedDate | ServicePaidDate | ServiceAllowedAmt |
1/2/2017 | 1/9/2017 | $143.16 |
1/16/2017 | 2/23/2017 | $339.20 |
1/13/2017 | 3/1/2017 | $478.00 |
1/19/2017 | 4/30/2017 | $342.00 |
1/6/2017 | 5/20/2017 | $206.05 |
1/31/2017 | 6/15/2017 | $589.00 |
1/10/2017 | 1/28/2017 | $123.63 |
1/26/2017 | 2/18/2017 | $300.00 |
1/9/2017 | 3/3/2017 | $653.00 |
1/3/2017 | 6/6/2017 | $23.00 |
2/23/2017 | 3/6/2017 | $103.56 |
2/6/2017 | 4/1/2017 | $78.00 |
2/4/2017 | 2/26/2017 | $2,076.00 |
2/26/2017 | 3/26/2017 | $3,906.00 |
2/18/2017 | 4/6/2017 | $20.00 |
2/8/2017 | 5/5/2017 | $212.00 |
2/13/2017 | 4/26/2017 | $42.13 |
2/3/2017 | 5/16/2017 | $99.57 |
2/8/2017 | 3/20/2017 | $78.00 |
2/13/2017 | 4/16/2017 | $90.00 |
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.
Regards,
Niha
can you share your expression
Hello,
I used a Pivot Table with dimension in Row as Service Year and in Column and Expression is just Sum(ServiceAllowedAmount). I think some think has to be modified here.
Niha
Hi,
I think I got the answers . Thanks