-
1. Re: BAR Chart with "All" value
Sandeep Das Aug 29, 2017 12:57 AM (in response to karthik Valluri)1 of 1 people found this helpful -
2. Re: BAR Chart with "All" value
Mahfooj Khan Aug 29, 2017 1:02 AM (in response to karthik Valluri)Hi Kartik,
I guess you required help from LOD{} in this scenario.
For All you may try this calculation
{SUM(Value)} //This will always returns the total value until you don't use any context filter on any dimension in your view.
Give a try and let us know if this help.
Another way using parameter.
Mahfooj
-
-
4. Re: BAR Chart with "All" value
Sankarmagesh Rajan Aug 29, 2017 1:54 AM (in response to karthik Valluri)Hi Karthik
Create query as
SELECT [Orders].[Category] AS [Category],
[Orders].[OrderDate] AS [OrderDate],
[Orders].[OrderID] AS [OrderID],
[Orders].[Profit] AS [Profit],
[Orders].[Quantity] AS [Quantity],
[Orders].[Sales] AS [Sales],
[Orders].[Segment] AS [Segment],
[Orders].[SubCategory] AS [SubCategory],
'Data' as [Data]
FROM [dbo].[Orders] [Orders]
Union All
SELECT [Orders].[Category] AS [Category],
[Orders].[OrderDate] AS [OrderDate],
[Orders].[OrderID] AS [OrderID],
[Orders].[Profit] AS [Profit],
[Orders].[Quantity] AS [Quantity],
[Orders].[Sales] AS [Sales],
[Orders].[Segment] AS [Segment],
[Orders].[SubCategory] AS [SubCategory],
'All' as [Data]
FROM [dbo].[Orders] [Orders]
Create Calculation as
if ['Data']='Data' then [Category]
else 'All'
END
Drag this calc into row and sales into column.
Thanks
sankar
-
5. Re: BAR Chart with "All" value
karthik Valluri Aug 29, 2017 2:49 AM (in response to karthik Valluri)Thank you guys...Sandeep's solution helps..but my main intention was to achieve drill through in the "All" bar in case the user selects to drill-through the "All" bar ( for that reason i used actions) instead of individual bars.
-
6. Re: BAR Chart with "All" value
Sandeep Das Aug 29, 2017 3:23 AM (in response to karthik Valluri)Yes for drill through thats right way to do.
If my reply helped you to solve your query then please mark my reply as answered one.
Thanks
Sandeep