Results based on Column`

Question

Hi All,I am working on scenario where I nee dto have data for PO DOC No but with out having material no in visualIn above picture you see material no is available, but I need to have same data even Material Number is taken off.&nbsp;But If I take material no off it shows as below&nbsp;But I want no of rows remain 5 and even If I remove material number from visual.&nbsp;Please help.

mussaenda · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Click the slicer, go to format, edit interactions, and remove the interaction to the table.

&nbsp;
Once finished, click again the edit interactions so it the icons will disappear.
&nbsp;
Hope this helps.

anonymous · Answer

If you see in picture 2 when I take off material no it chnages the no of rows to 3 and even values of FinalCS QTY is not right

I dont want to disable the intreaction, but want to take off material no but still it should show 5 rows.

mussaenda · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
Sorry I didn't understand your concern before.
It's happening because it summarizes your data.
And I believe your&nbsp;&nbsp;FinalCS QTY is a measure.
&nbsp;
On visualizations pane, you can right click on the fields and try to select Don't Summarize on columns

anonymous · Answer

Yes FinacsQTy is measure hence we cant right click and make it dont SUmmarize, we can do that only on direct columns and NOT on custom measure, below are measure formulasFinalcsQTY = DIVIDE([Scheduled CS Qty],[CS_Conv])whereScheduled CS Qty = ([Scheduled Qty]*(divide(SUM('Open Purchase Orders'[Con Numerator Baseunit]),SUM('Open Purchase Orders'[Conv Denominator Baseunit])))) andCS_Conv = sum('Product Material Dim'[CS Conv])

anonymous · Answer

we create FinalCSQty for each Material No without having Material no in visual

Forum Discussion

Results based on Column`

7 Replies

Related content

Sequential Order column based on multiple criteria

Add duplicate row based on column

Calculate new column based on another column's text

Matrix column based on other matrix columns

Download cypher results