Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi friends,
I want to show opening stock value
for example if i click on month Jun the opening stock value should be the value of may 31.
In text box am able to get the crct value but if i take that in pivot table with month dimension it is not showing the correct value
Hi Gowtham,
Please provide sample data.
Hi Bro,
How many dimensions you are using in pivot.
when you sort a pivot table, you have to sort it first according to the first dimension, then according to the next, etc.
Hi bro ajsjoshua
sorting is not the problem now i want to shoe opening stock value
See the attachment
Hi Bro,
share ur expression.
I have shared the application da check t
Hi
Try like this
PICK(Match(%EXPRESSIONS,'OPENINGSTOCKNETWEIGHT','OPENINGSTONEWEIGHT'),
if(GetSelectedCount(SalesFY)>0 and GetSelectedCount(Month)>0,
$(=Sum({<PURCHASERETURNDATE={"$(=Date(Min(NumDate)-1))"},Day=,Month=,SalesFY=>}StockNETWEIGHT)),
Sum({<SalesFY={$(=Max(SalesFY))},StockDateNum={"$(=Floor(MonthEnd(StockDateNum,-1)) )"},Month=>}StockNETWEIGHT)),
Implement this in every expression logic
in if first expression is working fine
second one is not working
if month & year is selected it is working fine.if i clear it is not working