Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Experts,
As shown below I have one DATA table. In which some SKU are common in different PLANT (e.g. SKU A).
I want to create a Pivot Table which will show the SKU which are common in two PLANT, other SKU to hide.
How to achieve the result, please guide.
Regards,
GT.
In that case, try adding DISTINCT to the condition
Sum({<SKU = {"=Count(DISTINCT PLANT) >= 2"}>} VALUE1)
Use this set analysis on all the expression of the pivot table to restrict to only those SKU which are available at 2 or more plants
{<SKU = {"=Count(Plant) >= 2"}>}
Dear Sunny_Talwar,
Thanks for looking into, I have used the SET expression i.e. Sum({<SKU = {"=Count( PLANT) >= 2"}>} VALUE1)
But it is also showing SKU "B" also because SKU B is having two orders. Please guide...
Regards,
GT.
In that case, try adding DISTINCT to the condition
Sum({<SKU = {"=Count(DISTINCT PLANT) >= 2"}>} VALUE1)
Thank you Sunny Talwar.... it is working exactly the way I want.
Thanks,
GT.