Horizontal dimensions and vertical calculations in pivot table

[deepakkrish]

Hi there

I have a problem with the calculation in a pivot table. I have a  2 dimensions(Assigned_group, Quarter) in pivot table, and one expression like (if((mChangeRequestStatusString <>'Cancelled'),Count(DISTINCT(radarTicketID)))).. i got an output in this format(output.jpg).

My requirement  is totally different, the requirement would be in the format like(Req.jpg).

Could you please help me on this?

[tracysmart · Accepted solution]

Hi

I think you can probably achieve this by simply dragging your Dimension for Quarter_MTTR to the right and up. Hold you mouse down and move your cursor. You will see a solid line indicating that you are moving the dimension.

Have a play around with this, does it solve your requirement?

Tracy

[Anil_Babu_Samineni]

You might Drag that Quarter Field from Vertical to horizontal of the above of If Conition

[deepakkrish]

Hi Tracy,

I got a solid line, but don't know it is possible to move right and up.

Can u explain briefly, how can i achieve this?

[deepakkrish]

I tried that also, I don't know where can i use  and write the expressions in presentation tab or expression tab?

[Anil_Babu_Samineni]

please share your application.

[deepakkrish]

I think it's not possible to share, because it is a very large size of application. please give me an other suggestion to get a output like (Req.jpg).

[deepakkrish]

Thank you Tracy & Anil babu, i got an output using the drag &drop method.