Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have products sold , and i want their count using % contribution with the ID column
I'm not quite sure I understand your question correctly. Maybe you could provide a bit more information on what data you have and what you want to calculate with it.
To determine the percentage share of a selected value in e.g. a table you can use something like:
Count(ID) / Count(total ID)
The keyword "total" makes it so all values in the current selection will be counted, regardless of the content of e.g. a row in a table.
=Dual(WeekDay(Date-1), Mod(WeekDay(Date) - 2 + 7, 7) + 1)
kindly help me on the correct code , the above graph when i select the values for saturday are on sunday
Try below expression.
=Dual(WeekDay([Date]-2), Mod(WeekDay([Date]) - 2 + 7, 7)+1 )
Let me know whether it works. If not, explain more on your requirement.
the above has failed , but when i write weekday(Date) i get the correct results however sunday starts on the graph
Count(ID)/Count(Total ID)
format as a %