I have gone through few posts regarding the workarounds of using countd with blending but none of the workaround works for me.
Please suggest me any other workaround where i need to use countd on one of the field from secondary datasource and use this calculation with one of the field in the primary datasource (i.e countd(cloumnx from primary datasource)/countd(columnx from secondary datasource)) without using or showing the blended column in the visualization.
I cannot attach the workbook because of the security of the client's data.
Thank you in advance.
I will utilize size() sometimes if I can create a view where every row (or column) contains the unique value to be counted.