Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have table like below basically I am doing recon between serverwise daily
Tab1:
"A" server
TransDate
.
.
NetRevenue_Amt
Inventory_Amt
CostofSales_Amt
Concatenate
"B" server
TransDate
.
.
NetRevenue_Amt
Inventory_Amt
CostofSales_Amt
Concatenate
"C" server
TransDate
.
.
NetRevenue_Amt
Inventory_Amt
CostofSales_Amt
I am creating the pivot as below
TrasDate A vs B B vs C A vs C
(Dimension)
I have created three pivot for NetRevenue and Inventory and Cost of Sales. But I want create only one pivot with filter box as below
FilterBox
------------
NetRevenue
Cost ofSales
Inventory
based on my selection on filter box it has show the serverwise difference in pivot
If I load it as crosstable I am getting value column as one field .is there any other way to get value column has only in filter box so that I would have one piot
T
You can create one data island for your filter value..like
Filter:
Load * Inline [
Filter
NetRevenue
Costofsales
Inventory
];
And you can use this value in your condional display in expression..(Using the subfield function )
Search Adhoc report or dynamic report in the search box
Hi Settu
Thanks for the reply.I understood about conditional display and coul not understand about using subfield function this scenario. Can you explain more about that your idea.