Hi
I am trying to make a SSRS report wherein the requirement is given as below but I am not exactly getting how is it getting summarized, and how do i exactly achieve it in ssrs report design.
The open invoices for the particular customer are as below
And the requirement is to summarize the above open invoices in exactly below manner (unable to understand how is it getting summarized) and also since its dimension summary report if i summarize it based on "Dimension-Location" or "Dimension-client" then in summary i should get only one lien but here the multiple invoices from above are getting summarized as below 5 lines
Any help is welcomed, please let me know how exactly do i achieve it.
