Hi
I have a vendors data based on Purchase date.
I have a data for 2014 and 2015.
1. Here I want to find the New vendors in 2015 who are not in 2014.. Here the dimension is Vendor. In metric I need to show 'Yes' as a value if he is a new vendor, else It should return 'No'..
2. And also I need to find the top 100 vendors contribution by Purchase value amount field . Let us take a scenario.
I have fields VendorName, ItemGroup and PurchaseValue . Here each ItemGroup will lhave multiple Vendors.
I need to show a chart ItemGroup as a dimension and 2 Metrics as 1.Top 100 vendors amount 2. Remaining vendors amount contribution.
Help me out.
regards
suman