Crosstab acting strangely
I have inserted crosstab in my report and it up as Column wise. Now number of days, jobs and percentage is coming up with no issues however when I try to add another percentage (set to column wise) it does not display it. To test this when I used it as row wise it worked perfectly.
What could be the problem ? Why doesn't it allow more than one percentage if done by column wise.
Here is how it is setup
Number of Days - 1 - 2 - 3
Number of Jobs - 1 -- 2 - 3
Percentage (%) - 1% 2% 3%
I want to add cumulative percentage which when I add into the summarised field it just disappears when I summarise it by column wise, if i do it row wise it shows up.
What could be the issue here?