Filter view with one of the dataverse column

[SG013]

HI All

In view i need to filter with the condition  Column A(aggregation Rollup column) > ColumnB(agreeg rollup column).

I am unable to filter one column is greater than Another column.

I have to give value in the filter ,but in my scenario i need to compare with another column value.

Could you please help me to achieve this

Appreciate your help in advance

Thanks

SG

[Jmanriquerios]

Hi @SG013 

In model driven apps it is not possible in the view designer to make this requirement
You should use Canvas App

[bscarlavai33]

Unfortunately this isn't possible with native views. You would need to do something custom like a PCF Control.

[Ankit1036]

it is not possible in view but you can create SSRS report for this 

[parvezghumra]

@SG013 I would recommend creating a temporary solution containing just the view you wish to modify. Then export this solution as unmanaged, extract it and modify the FetchXml of the view definition in the customisations.xml file as required (use FetchXml Builder tool in the XrmToolBox to help). Then compress the modified solution files again into a solution zip file and reimport it into the same environment. Publish customisations after import succeeds.

This is one of the few cases where modifying the customisations.xml outside of the maker portal is supported as the view designer won't help with this.

https://learn.microsoft.com/en-us/power-platform/alm/when-edit-customization-file

Alternatively you can modify the view as required directly within the FetchXml Builder tool. Use the option to open the query from the view and then save it back to the same view once modified 

Valueof is the property you need in your condition element of the FetchXml 

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/fetchxml/filter-rows?WT.mc_id=D...