Use of same field in filter and in row and column in pivot table

[suvechha_b]

Hi there,

How to use the same field "Risk Model Execution" in Row and Column of pivot table.

and make one as filter 1 and the other as filter 2 

Can it be done from the App which is available currently to me , as I can't edit script of the Model.

Thanks

[tresesco]

You can create a master item or use calculated dimension like:

=Aggr(YourField, YourField)

and use it in addition to your original field/dimension 

[suvechha_b]

Hi Tresesco,

Please kindly elaborate as I can't figure out.

Please kindly assist with my requirement is:

I have "Risk Model Execution Id" as filter1 which when selects gives the "As At Dt"  value which is the Row of the Matrix.

How to create another filter2 "Risk Model Execution Id" which can be also selected by user (can be yesterday or 1 week later) - will be in the column of the matrix i.e (Horizontal).

I don't have the sample file to upload.

Thanks

Suvechha