First of all,Please upload the twbx file which is a packaged File.
For creating a Pie chart u need 1or more dimension and 1 or 2 measures.
if it helps please mark the answer as correct and feel free to ping me whenever you face any problem.
Thanks for Your Time.i have 1 dimension and 1 Measure .
2.Amount --Corresponding Values for each Account
I place Amount in Columns and Account name in rows Shelf but Pie chart is not enable .
How to create twbx file ?
Create a .twbx with file-based data sources
When your workbook uses a file-based data source, such as Microsoft Excel or a text file, the data source will be included in the packaged workbook. Simply save the workbook as a packaged workbook (.twbx).
In the workbook, select File > Save As.
From the Save as type drop-down menu, select Tableau Packaged Workbook (*.twbx). Now you can send your workbook.
here are the formula and Calculated Dimension
it should be sum in formula but its showing Aggr.Y so
IF(sum(BAL_PERIOD_NET_CR-BAL_PERIOD_NET_DR)*-1 < 0 , sum(BAL_PERIOD_NET_CR-BAL_PERIOD_NET_DR), sum(BAL_PERIOD_NET_CR-BAL_PERIOD_NET_DR)*-1)
calculated Dimension for Group Account:
=IF([Balance Sheet Group]='Current Liabilites' , [GL Segment3 Description])
Its working fine but,
accrued Payroll---496,798.05 is small and amount figure not displaying on slice.
is there any other alternative to show that value.
1 of 1 people found this helpful
What I can tell you here is too use a Annotation to highlight the Value. I am in office and I m not having Tableau 10 installed.
As this is only having three values , you can also use Donut chart approach.
Formal Request : If any of the above answer is helpful, kindly mark is Helpful as well as correct answer