Tabular report Format:
Create then custom sql with union all
SELECT [Orders$].[Category] AS [Category],
[Orders$].[Order Date] AS [Order Date],
[Orders$].[Product Name] AS [Product Name],
[Orders$].[Profit] AS [Profit],
[Orders$].[Region] AS [Region],
[Orders$].[Row ID] AS [Row ID],
[Orders$].[Sales] AS [Sales],
[Orders$].[Segment] AS [Segment],
[Orders$].[Ship Mode] AS [Ship Mode],
[Orders$].[State] AS [State],
[Orders$].[Sub-Category] AS [Sub-Category],
"Data" as [Alias]
"Total" as [Alias]
I have created one column name as [Alias]
Create calculation as
when "Data" then [Region]
when "Total" then [Category]
Drag this field into column and category as well.
Create the calculation [one]
Drag ship mode and measure name into row .
Create the calculation with as below [Met or not met]
Drag the new calculated field [one] into row and select min
Drag [one] again to row and select min and dual axis.
Drag measure value into marks card
Drag [Met or not met] into marks text
Drag sheet into dashboard and get each category total as well measure with text view.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.