Hi please help me to resolve the below issue.
input file :
Type Of Circuit | Month | Avg % Uptym |
---|
| Aug 2011 | 99.713 |
VPN-NATIONAL | Sep 2011 | 99.95 |
| Jul 2011 | 99.987 |
| Aug 2011 | 99.997 |
| Jul 2011 | 100 |
MANAGEDSERVICES | Aug 2011 | 100 |
INSTACC Hosted | Sep 2011 | 100 |
NPLC | Sep 2011 | 100 |
after formula pivot result is as below:
dimention (Type od circuit,month)
Expression sum(Avg % Uptime)
Type Of Circuit | Month | Jul 2011 | Aug 2011 | Sep 2011 |
---|
INSTACC Hosted | | - | - | 100 |
MANAGEDSERVICES | | - | 100 | - |
NPLC | | - | - | 100 |
VPN-NATIONAL | | - | - | 99.95 |
- | | 299.987 | 199.71 | - |
again i want to replace null value with 100 which i did using presentation tab.
Type Of Circuit | Month | Jul 2011 | Aug 2011 | Sep 2011 |
---|
INSTACC Hosted | | 100.00 | 100.00 | 100 |
MANAGEDSERVICES | | 100.00 | 100 | 100.00 |
NPLC | | 100.00 | 100.00 | 100 |
VPN-NATIONAL | | 100.00 | 100.00 | 99.95 |
100.00 | | 299.987 | 199.71 | 100.00 |
now i want the last result in bar chart. but i am unable to set blank as 100 in bar chart.
Please help. attaching sample qvw for reference