Can we build a table in calculated filed like attached image?

[aigsandip]

Hi,

I need to build the like below:

Can we build the above table? 

How can we build the fileds at Left Side like Gross Sales, REBATE, RXs etc?means Left Side columns are measures, and should show under PRODUCT SET DESCRIPTION collumn. So, can we create column like this?

[Anonymous · Accepted solution]

Hi, @aigsandip 

If you want to do this in Report builder, you can use the matrix view, like I demonstrated, with the Major field in Row, the Year field in Column, and the Amount field in the space in the bottom right corner.

Then modify its formatting bar

Here is my preview:

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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

[BeaBF]

@aigsandip Hi! Yes, you can create a table like that with the Matrix Visual. If you paste some sample data, I can help you with the construction.

BBF