SSRS Keep grouping but merge data values
I have an SSRS report that contains 4 columns: Customer, Postcode, Date and Value. Customer, Postcode and Date are my groups and Value is my data.
I want to end up with something that looks like the image below:
e.g. Customer A ordered £50 on 01/01/2024, £30 on 02/01/2024 and £20 on 03/04/2024, so has a total of £100. This is what I want to show, not the individual £50, £30, and £20.
I know how to get Customer and Postcode to appear every row (rather than merged because of the grouping), however I'm not sure how (or even if there's a way) to merge the overall value for Customer. Any help is appreciated :)
As you only need grouping at one end of the tablix then you can do this. It's not very intuitive but it's simple.
Create a table and add Date, PostCode and Customer in that order. Then add a parent group that groups by customer. This will add a group column at the start with the customer field already in place, change this to use the value column (so the expression will be =SUM(Fields!Value.Value) and adjust the header accordingly.
Finally, on the tablix properties, chenge the LayoutDirection property from LTR to RTL.
Here's a quick GIF to show you how I did it. (open in new tab to see it larger if required)
- Global matrix doesn't return the right value when read
- How to calculate matrix determinant? n*n or just 5*5
- Using spfun with two identically ordered sparse matrices
- Create clusters using correlation matrix in Python
- Numpy element-wise addition with multiple arrays
- How do I shuffle a specific 2D cell along the z-axis in a numpy 3D matrix?
- Convert dataframe to matrix and create chord diagram
- Solving a simple matrix differential equation
- Stream through a portion of a 2D array in Java
- What am I doing wrong when loading a skeleton and animation?
- Transpose/Unzip Function (inverse of zip)?
- How can I print a matrix using numpy without ellipsis in the middle?
- Rust Macro count repetitions of nested match
- Selecting a column vector from a matrix in Python
- How to Save a Matrix as a PNG Image and Reload it to Recover the Original Matrix
- Why do I divide Z by W in a perspective projection in OpenGL?
- Clustering with a distance matrix
- Efficiently Calculating a Euclidean Distance Matrix Using Numpy
- Confusion between C++ and OpenGL matrix order (row-major vs column-major)
- Generating all sequences and probabilities for a random process in R
- C code reading only part of a matrix correctly
- Assertion Failure in Eigen Matrix Broadcasting: Dimension Mismatch in Neural Network Forward Pass
- How to efficiently multiply all non-diagonal elements by a constant in a pandas DataFrame?
- Proving correctness of Matrix Addition
- How to send sparse vectors and matrices over ZeroMQ?
- Numpy array does not correctly update in Gaussian elimination program
- Spread not works for Array(16) _wgpuMatrix.mat4.invert return NUll filled array
- Concatenate a few row vectors into a matrix
- How to put ones in random places in matrix (or 2D array) of zeroes in C++
- Find column indices of a matrix entries that are repeated values