Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I want to get Count of IDs and Amount of those new IDs which not exist in previous month but newly occurred in current month and will be showing output in straight table with Dimension (ID) and Measures (Count of new ID & Amount of new ID) .
IDs can be have Amount in previous and current month but new IDs will have Amount only in current month.
Sample data is as below:
Many Thanks
@U_Waqar Not sure on how to create a straight table. But I was able to create a KPI to count the ID and the New Amount. You can make it more dynamic using the below Idea.
Count of IDs: Count(distinct{<ID=P({<Month={'May'}>}ID)>/<ID=P({<Month={'June'}>}ID)>} ID)
Amount of New ID: Sum(distinct{<ID=P({<Month={'May'}>}ID)>/<ID=P({<Month={'June'}>}ID)>} Amount)
Create a Filter for Month and check if you are getting correct result as expected.
@U_Waqar Not sure on how to create a straight table. But I was able to create a KPI to count the ID and the New Amount. You can make it more dynamic using the below Idea.
Count of IDs: Count(distinct{<ID=P({<Month={'May'}>}ID)>/<ID=P({<Month={'June'}>}ID)>} ID)
Amount of New ID: Sum(distinct{<ID=P({<Month={'May'}>}ID)>/<ID=P({<Month={'June'}>}ID)>} Amount)
Create a Filter for Month and check if you are getting correct result as expected.