Help with Cross tabs
Posted: Tue Apr 25, 2017 9:00 pm
Hey, I have a few conditions I need to narrow down with cross tabs. I am trying to build a leakage report, so I am using cross tabs to create data tables. These data tables hold a set of employee names and their leakage amounts, one cross tab for each applicable title.
First, is there a way to make multiple cross tabs auto fit horizontally with each other? I created about 5 cross tabs with relevant data, but their sizes can vary depending on the name and values in the columns. What I want to do is make it so the cross tabs won't overlap horizontally with each other, but will remain a small distance apart.
Secondly, is there a way for the cross tabs to not even populate if no data is present for them? For example, the row headers for my cross tabs are using a pool of employee names depending on their title. Not every employee should be on this as only a few will be flagged for leakage per month. I created a column with a calculation that turns the employee's name to NULL if they do not have a leakage value, in an attempt to ignore this row of data. I created a filter on the cross tab to exclude these NULL values, that is working fine. Some of the categories, though, will frequently not have any information to populate, but the cross tab populates with a few boxes. No useful information, just relative "junk". If would be perfect if the Cross tabs only appear if there is value for them to populate.
First, is there a way to make multiple cross tabs auto fit horizontally with each other? I created about 5 cross tabs with relevant data, but their sizes can vary depending on the name and values in the columns. What I want to do is make it so the cross tabs won't overlap horizontally with each other, but will remain a small distance apart.
Secondly, is there a way for the cross tabs to not even populate if no data is present for them? For example, the row headers for my cross tabs are using a pool of employee names depending on their title. Not every employee should be on this as only a few will be flagged for leakage per month. I created a column with a calculation that turns the employee's name to NULL if they do not have a leakage value, in an attempt to ignore this row of data. I created a filter on the cross tab to exclude these NULL values, that is working fine. Some of the categories, though, will frequently not have any information to populate, but the cross tab populates with a few boxes. No useful information, just relative "junk". If would be perfect if the Cross tabs only appear if there is value for them to populate.