Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have product sales data with history.A particular product has to be sold on some date ex:04/12/2013 as per March month end data.But as of today data that sale date for product may change to 04/24/2013.I want find number of distinct products with two sale dates (One old sale date ad one new sale date).All the history data and daily data are in same table with flags.I tried lot of expessions to find the number.But no solution so far.Any Suggestions?
May be
Count({<ProductID={"=Count(Distinct SaleDate)>=2"}>} ProductID)
With product id has dimension
Hi,
Use ProductID as dimension in chart and use the following expression
If(Count(DISTINCT ProductID)>=2, Count(DISTINCT ProductID), Null())
Hope this helps you.
Regards,
Jagan.
Thanks for the reply.I tried no success.I will simplify my requirement.It may be helpful.I want to find the products which have postponed sale dates as of daily data compared to month end data.Product will have some sale dates as of Month end data but as of daily data those sale dates may postoponed to future date.
Thanks for the reply.I tried it did not work.
Hi,
Can you attach sample file?
Regards,
Jagan.