Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Week | OneItem | TwoItems | 3>= Items | Total | OneItem % | TwoItems % | 3>= Items % | |
40 | 95.0 | 56.0 | 70.0 | 221 | 43.0% | 25.3% | 31.7% | |
If the counter has value 1 -finding how many line item has value 1 | ||||||||
If the counter has value 2 -finding how many line item has value 2 | ||||||||
If the counter has value 3 or greater than 3 values -finding how many line item has value 3 and morethan 3 | ||||||||
Column(1)+Column(2)+column(3) - I am able to get the total | 221 | |||||||
For reporting I need to display the %of each item per cal week | ||||||||
Straight table -Column(1)/Column(4) -I can find the % of One Item | ||||||||
OneItem % | TwoItems % | 3>= Items % | ||||||
43.0% | 25.3% | 31.7% | ||||||
For the Bar chart - how can I hide the columns below and find the % and display the values as % | ||||||||
OneItem | TwoItems | 3>= Items | Total | |||||
95.0 | 56.0 | 70.0 | 221 | |||||
I am working only Ver8.2 -I can't implement Set analysis here | ||||||||
Advance Thanks for your help |
First, you don't have to use the same exact expresions in the bar chart as you use in the staright table. You can use:
(number of line item has value 1) / (number ofline item has value 1 or more)
(number of line item has value 2) / (number ofline item has value 1 or more)
(number of line item has value 3 or more) / (number ofline item has value 1 or more)
Second, if for some reason you have to use the same expressions - try to check "Invisible" on the expression properties.
First, you don't have to use the same exact expresions in the bar chart as you use in the staright table. You can use:
(number of line item has value 1) / (number ofline item has value 1 or more)
(number of line item has value 2) / (number ofline item has value 1 or more)
(number of line item has value 3 or more) / (number ofline item has value 1 or more)
Second, if for some reason you have to use the same expressions - try to check "Invisible" on the expression properties.
Thanks Michael -It is working correctly