Ideally you would join the text files (http://kb.tableausoftware.com/articles/knowledgebase/joining-excel-worksheets) so that the type information is available. However I don't quite understand your example - you should be able to pull that into three columns by indicating that it's a csv.
The problem is that we don't know how many cost centers are per transaction lines, e.g., one line may contain 1 cost center, another one - 6 cost centers separated by comma.
The simplest solution would be to create as many new columns as there are object types, however there may be unnecessary columns.
We are currently looking for BI tool which could solve this problem. Some tools are not flexible and each time the cost centers or cost center types change we must change data import procedures.
hey can any one pls help me to create table with multiple columns and sub colums in single worksheet
Rashmi, Can you attach a screen shot or sample data. It is difficult to understand what you are looking for
Aldevinas - It actually doesn't make any sense. That should not be the way you should be using your data. You need to change it to some standard, and here is why:
If we assume we have two rows
you want to put it into multiple columns so, the columns for the first one will be
SALESMAN, REGION, PRODUCT
and in the second case it should be
SALESMAN, PRODUCT (which make no sense)
even if we achieve what you want (break into multiple columns) the data will look something like this (no sense)
SALESMAN REGION PRODUCT
1. JOHN EAST PIPES
2. JAMES PIPES
To make more sense, you should save the raw data as:
2. JAMES, ,PIPES
i.e. keeping the values for other cost centers NULL.
The other way is to save you data in unpivoted format
1. ..other common value in the row.. SALESMAN JOHN
2. ..other common value in the row.. REGION EAST
3 ...other common value in the row.. PRODUCT PIPES
8 ...other common value in the row.. SALESMAN JAMES
9 ...other common value in the row.. PRODUCT PIPES
I hope you understand this hint.
Rashmi - If you can share the data, I may help.
This thread is from 2012/2013...
In the above I showed the 'Achieved' and 'Not Achieved' numbers against 'Synced By'.
Now I would like to sum all Achieved and Not Achieved separately to show in dashboard.
Also I would like to count number of Achieved 'Synced by' and Not Achieved 'Synced by' separately.
How can we do this activity?
Any help greatly appreciable.
Thanks a lot.