hello,let say i have date like below
supplier parts value
A ice 100
B ice 200
C ice 300
D ice 400
J chemical 200
L sugar 500
M sugar 1000
...............................
...............................
.................. so on
let say i got thousands of supplier
i want to display only those parts which has been supplier by more then one Supplier and i want to show % of that particular supplier among other supplier who supplies same parts.i mean
supplier part value %of that supplier
A ice 100 100/100+200+300+400
B ice 200 200/100+200+300+400
C ice 300 300/100+200+300+400
D ice 400 400/100+200+300+400
L sugar 500 500/1000+500
M sugar 1000 1000/1000+500
Note :i dont want to display chemical because it is supplied by only one supplier
so what expressions do i need write
I tried this in calculated dimension to display only those parts which has multiple supplier
1)
if(count(distinct supplier)>1,part) (Invalid dimension error)
2)%of that supplier
sum(%of that supplier)/sum(total %of that supplier)
which is also wrong
how to write this expressions
Thanks
Naveen
