Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Problem with subtotals in matrix for multiple months

Hello,

 

I've looked at the forums and found a couple items that seemed to be related but none quote the same as what I'm seeing. I'm using a separate date table to relate to other separate table values for calculations. 

 

 

If I use a date slicer and filter down to a single month, the sums for the column are correct but still not on the rows. 

 

Please let me know if I can help with any additional details, thanks in advance for any help.

 

Regards,

Seth Calkins

Need Help

3 Replies

  • dax's avatar
    dax
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous , 

    If possible could you please inform me more detailed information(such as your expected output and your sample data (by OneDrive for Business))? Then I will help you more correctly.

    Please do mask sensitive data before uploading.

    Thanks for your understanding and support.
    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I took a look at Greg's response and I could not figure out a way to detail the month in the columns the way that the link Greg shared for "measures totals, the final word" details, but that looks exactly like what I want. I can't use a date field in my v_rpt_agreementlist table as it only has the start and end dates not constant updates for each month. I used v_rpt_time for the constant updates to show which agreements are active to capture that monthly amount.

       

      My relationships are below 

       

      1 way join between time and dates on date_entered_utc (from time) to dates (used to identify column headers for month)

      1 way join between agreement and time on agr_header_recid (which was used to identify the rows)

       

       

      Zoe Zhi, I tried to filter down the data and you can access at the below link. It no longer will show the billing amount in the matrix, but contains the agreement table that has the billing amount and dates table that I was previously using.

       

      https://abshosting-my.sharepoint.com/:f:/g/personal/scalkins_advancedbusinesssolutions_com/EmAwwYtFAGtBrIr1y5jU-DYBtN1xqvz-iwTnqIxtjWFtdg?e=qV6mXe

       

      Thank you everyone for your help.