Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good day -
I have an expression I am trying to build where I want to be able to count the number of transactions regardless of the filter selection for just one filter.
Here is the context for the report. I have a set of transaction data with the following key fields / dimensions:
Month/Year (Dimension in Report)
Region (Filter)
Category (Filter)
Transaction_ID (Measure in Report)
I have the report set up where the dimension is Month/Year, and the Measure is a Count of the Transaction_ID.
I run by setting a filter for the region and category. While I am able to get the total transactions for that combination, I would also like to be able to show the % of total transactions for the Month/Year and Region.
The calc would look something like:
COUNT(Distinct transaction_id) (by month/year, region, and category)
/
COUNT(Distinct transaction_id) (by month/year and region)
I have tested with TOTAL and it only disregards the Dimension in the report.
Any suggestions on how to make this happen would be greatly appreciated.
Thanks,
Mitch
I was able to resolve the basic need on this on by using Set Expression and the $ qualifier for the appropriate field - COUNT( {$<Category=>} Transaction_ID)
This allows the selection on Region to persist, but disregards the selection for Category which is what was needed.
Thanks,
Mitch
Please post some sample data an expected output
I was able to resolve the basic need on this on by using Set Expression and the $ qualifier for the appropriate field - COUNT( {$<Category=>} Transaction_ID)
This allows the selection on Region to persist, but disregards the selection for Category which is what was needed.
Thanks,
Mitch