Georgina Pollock Posted July 10, 2019 Share Posted July 10, 2019 I have a cross table where I want to compare Fy19 percentages to Fy20 percentages to get a % change. the cell values are as follows UniqueCount(If([Task List Attached],[Work Order Number],null)) as [WO with task list] UniqueCount([Work Order Number]) as [Total WO] UniqueCount(If([Task List Attached],[Work Order Number],null)) / UniqueCount([Work Order Number]) as [%] How do I do this Link to comment Share on other sites More sharing options...
Khushboo Rabadia Posted July 19, 2019 Share Posted July 19, 2019 Hi, The attached screenshot is not visible. Can you provide the sample dxp with sample data Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now